Why don't more people use a case-sensitive SQL Server? I was installing the latest 1.x version of DotNetNuke and had some database problems. I found the database create scripts in the "database" subdirectory and decided I'd run them individually and see if anything pops up. It sure did! This code only works on a case-insensitive database. If your database is case-sensitive, the scripts fail. Why? How hard is it to write it against a case-sensitive database? That will guarantee that it will run on either one.
Very frustrating. I recall having the same problem when playing around with setting up a database for managing ASP.NET session state. Arghh!