SQL 2000 Server collation

[macphisto]

Is there any ways to change SQL Server collation ???
to a different one ?
with out reinstalling SQL ?
and what effect would it have on my existing databases !

Thanx in advance
Macphisto

 

[tlbroadbent]

Check the online documentation. It explains what can and cannot be done regarding collation changes.

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

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.