Collation question ? Please soemone....
-
Hi,
I have a SQL server standard edition that I just installed. I want the collation after installation to read :
SQL_Latin1_General_CP1_CI_AI , but it shows
SQL_Latin1_General_CI_AI......
My question is how in earth I can set the "CP1" during installation ? Can I change this after installation. NOTE, I want to set this for the complete installation, it will not be enough to change it only on the different database levels
Help extremelly appreciated !!
//Helmut
-
Hi Helmut,
What version of SQL Server are we talking here?
-
Sorry, meant to post this link too.
http://support.microsoft.com/kb/325335
Check out the bit about "Change the collation of the master database in SQL Server 2000"
-
Hi
I'm running SQL server 2000 standard edition
-
Unfortunately you're in for a world of grief.
Your options are:
a) reinstall SQL Server and choose exactly the correct collation you need.
b) rebuild master
Either way you will need to either recreate all databases and objects created since the install or alter the collation settings for each.
http://msdn2.microsoft.com/en-us/library/aa176549(SQL.80).aspx
http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp
http://support.microsoft.com/kb/325335
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=471
http://www.microsoft.com/windowsserver2003/sbs/docs/SQLServerSetup.doc
You select the collation when installing SQL Server 2000. When running through the install options, select the "Custom" install type instead of "Typical".
Sorry to be the bearer of bad news.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply