August 4, 2002 at 3:33 am
Hi
What is the default collation SQL 2000 Server takes during installation on Windows 2000?
Can it be chosen during installtion of SQL 2000 or does it depend on my regional options and according them the SQL 2000 server default collation will be selected?
Why can it happen that the user datebases have collation Latin1_General_CI_AS and the tempdb has collation SQL_Latin1_General_CP1_CI_AS?
I ran into problems as temporary data had to be compared residing in temp db's on tempdb and the result was a collation conflict!
In the BOL it says:
"When you install an instance of SQL Server, you can specify the default collation for that instance during setup"
but I had no window or dialog during installation of SQL2000 Personal Edition where I could select the collation.
How can I change default collation of SQL 2000 Server?
Anyone has some more informations?
Thanks
mipo
August 4, 2002 at 6:23 am
I think it defaults to 1252 - case insensitive. Tempdb will have the collation of model.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply