Change Coalition for Instance

Hi All
Anyone able to tell me how I can change the coallition type for the server
instance (not the database) without reinstalling?
Thanks
Pete"P" <P@.discussions.microsoft.com> wrote in message
news:9283B05F-6FB5-4698-BF2C-1A7A0E328932@.microsoft.com...
> Hi All
> Anyone able to tell me how I can change the coallition type for the server
> instance (not the database) without reinstalling?
> Thanks
> Pete
AFAIK, no.
When you install, a default collation is chosen (if you do a typical
install) based on certain criteria and then the master, model, msdb, tempdb
and Distribution database are set to that default collation.
You *may* try doing an alter database to change the collation for each
database in the system. If you take a look at the sysservers in master,
there are two collation settings there, but I don't have my charts with me
so I don't know the relationships that they represent.
Hope this helps somewhat.
Rick Sawtell
MCT, MCSD, MCDBA|||rebuildm.exe
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"P" <P@.discussions.microsoft.com> wrote in message
news:9283B05F-6FB5-4698-BF2C-1A7A0E328932@.microsoft.com...
> Hi All
> Anyone able to tell me how I can change the coallition type for the server
> instance (not the database) without reinstalling?
> Thanks
> Pete