Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Determine installed sort order

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-14 : 08:40:21
Clarie writes "How do you determine the installed sort order (dictionary, binary, etc.) of an existing SQL Server installation? I'm looking for something like the @@version to determine the level of service pack. Any help will be greatly appreciated!"

mphelps
Starting Member

12 Posts

Posted - 2002-01-14 : 08:50:11
Use the following stored procedure found in Master database

sp_helpsort

quote:
I don't suffer from insanity, I enjoy every second of it.


Go to Top of Page
   

- Advertisement -