|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > SQL 2K Changing Sort Order
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2K Changing Sort Order
|
|
|
| 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.
| |
| Anith Sen 2002-12-10, 3:23 pm |
| Check:
http://msdn.microsoft.com/library/e..._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)
|
|
|
|
|