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 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
>|||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...
>> How can I find out and change the Default sort option in the Server for
>> SQL 2K?
>> Thanks in advance.
>> Perayu
>

How to find my sql server's product version

Hi,
I need to know the way to find my sql server's product
version.
Thanks in advance.
Deda ZhengHi,
In query analyzer run this query
select @.@.version
Cheers,
Shiva.
Chennai.
"dzheng" <dzheng@.weather.com> wrote in message
news:091501c3455c$386e3400$a001280a@.phx.gbl...
> Hi,
> I need to know the way to find my sql server's product
> version.
> Thanks in advance.
> Deda Zheng
>|||If you are running SQL Server 2000 you can also use the SERVERPROPERTY
function:
SELECT SERVERPROPERTY('Edition')
SELECT SERVERPROPERTY('ProductVersion')
SELECT SERVERPROPERTY('ProductLevel')
--
Alan Brewer [MSFT]
Lead Technical Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights