Very Computer

by n. » Wed, 11 Dec 2002 22:31:20

How do you change the Sort Order of an existing database. I'm under the
impression you can do this in SQL2K, in the same server instance, on a DB by
DB basis.

by **Anith Se** » Wed, 11 Dec 2002 22:36:29

Check:
http://msdn.microsoft.com/library/en-us/architec/8_ar_da_819v.asp

Also do:

SELECT *
FROM ::fn_helpcollations()
WHERE [Name] = SERVERPROPERTY('collation')

or

sp_helpsort

See details about all the above in SQL Server Books Online.

--
- Anith
(Please respond only to newsgroups)

Very Computer

SQL 2K Changing Sort Order

SQL 2K Changing Sort Order

SQL 2K Changing Sort Order