November 18, 2004 at 11:07 pm
Dear Gurus, I had sqlserver 2000 in sap 4.7. sap needs collation SQL_Latin1_general_cp850_BIN2, but by default after installation SQL_Latin1_general_cp850_BIN is coming. How can i change this collation settings now.
Can any one help me out to solve this problem.
Thanks And Regards ravi |
November 26, 2004 at 11:57 pm
Bad news and good news.
Bad News - You cannot change collation settings on the fly for the server ....
What you need to do is rebuild your system databases if you want to change the collation settings.
To do this - do a books online search for command rebuildm.exe. But at the end of the exercise of rebuildm, you'll be left with a cleaned up master and all other system databases with the new collation set. i.e all logins, jobs, etc are lost.
For your user databases, the mdf, ndf, ldf files will still be intact.... you will be able to attach them back but remember you'll be left with orphaned accounts in the sysusers table.
Do be careful before you attempt this. Do readup extensively on topics and KB articles on how to rebuild your master db before you try this. It is not for the faint hearted ...
Good News
- With SQL Server 2000, collation setting at the database level can be different from the default that you installed with. You do this at the point of creating a NEW Database by selecting it to be the collation setting that you require.
( so you may not need to rebuildm.exe if all you need is the collation for one of the databases -- i dunno sap - so i cannot say if it works for you ).
But once you have created the database with a collation setting - i am not aware if there is a way to change the collation setting at the db level. I anticipate not !
Hope that helps
/Sukhdev S
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply