From: Erland Sommarskog on
Joe Cool (joecool1969(a)live.com) writes:
> I was not aware that you could define a database with no collation.

You can't, and I can't say that I said so. What I said is that I recommend
against using SQL collations, and that you are better off using Windows
collation.

You can leave out the COLLATE clause when you create a database, but
then you will inherit the server collation. (Which also should be a
Windows collation.)


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx