Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 default (out of the box) SQL server collation

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2010-04-23 : 15:46:16
Does anyone know if the default (out of the box) SQL server collation is different for SQL Server 2000 Enterprise and SQL Server 2005 Standard?

I have both in my environment and all of the SQL Server 2000 Enterprise Instances have a server collation of SQL_Latin1_General_CP1_CI_AS and all of the SQL Server 2005 Standard Instance have a server collation of Latin1_General_CI_AI

Some of the installs I did.. some I did not. as far as I know, the server collation was not changed from whatever the default is on install.

I've googled this and can't come up with an answer.. can anyone shed some light?
   

- Advertisement -