change master collation
-
how is it possible to change master Collation in SQL Server 2008.
-
how is it possible to change master Collation in SQL Server 2008.
If you are referring to change the ms sql server instance's collation refer this link: http://msdn.microsoft.com/en-us/library/ms179254.aspx[^] But remember to "detach" user defined databases as they will be dropped when you execute these steps. You can "reattach" the databases when you are done with changing the collation. If you want to change the collation of a database alone you could use the alter database command. Check out this link: http://msdn.microsoft.com/en-us/library/ms174269.aspx[^] As you said master collation, I guess you mean the server instance's collation. Either ways remember to detach (in case changing the server collation) or take a backup (in case you are using alter database cmd) of user databases.
Cheers, Karthik