Default Collation

Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
2000?It depends on the system locale. If the system locale is US, then yes. If something else than US,
the default is a Windows collation matching your system locale.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegroups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
John