How to find out the Default Sort Option.

How can I find out and change the Default sort option in the Server for SQL
2K?
Thanks in advance.
Perayusp_helpsort shows you the current sort order. You may need to rebuild master
to change it.
"Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
> How can I find out and change the Default sort option in the Server for
> SQL 2K?
> Thanks in advance.
> Perayu
>|||Also DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default
collation for a database
can differ from the default for the instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kalyan Yella" <kyella@.comcast.net> wrote in message news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.
gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild mast
er to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>|||Many Thanks!
Perayu
"Kalyan Yella" <kyella@.comcast.net> wrote in message
news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild
> master to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>