July 5, 2003 at 5:17 pm
Has anyone every had problems/success with changing the server collation settings after install on SQL Server 2000.
BOL says to run Rebuildm.exe to rebuild server collation settings.
Anyone has any advice it would be great.
Thanks
Billy
July 7, 2003 at 7:31 am
That is the only way that I know to change the settings for the server. Not entirely positive but I believe any database created prior to the rebuild of the master database will be under the old collation. You can use alter database to change the database collation but that is not entirely clean. Someone else posted a similar question in an earlier post that it may be worth reading that for more information as well.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply