server collation

[goransaler]

Hello

I wonder if it is possible to see what server collation
a SQL Server 7.0 whithout starting the sql server
in a file or something

and if there isn't any way

if i start the sql server what query can i do to find out

 

[goransaler]

Please anyone
What query do i do to see what collation my sql server 7.0 use


please help

 

[SemperFiDownUnda]

You need to do this but don't have access to the server?

 

[osjohnm]

Hi

You have to connect to the server. Execute sp_helpsort to return the collation. Alternatively right click on the server in EM and select properties, the collation is displayed there.

Hope this helps

John

 

[goransaler]

thanks