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)
 change sort order for SQL Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-28 : 09:08:59
Joerg writes "Hi all,

I would like to change the default sort order (case sensitiv - chosen while installing SQL Server 2000) to insensitiv. AFAIK I have to reinstall SQL Server the change the values in the master db. But there is also a stored procedure sp_helpsort to change the sort order from insensitiv to sensitiv. I think there must be a way to do the same in the other direction without reinstalling SQL Server 2000.

Any help would be great

Thanks

Joerg"
   

- Advertisement -