From: Erland Sommarskog on
Joe Cool (joecool1969(a) 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

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)

Links for SQL Server Books Online:
SQL 2008:
SQL 2005:
SQL 2000: