This SQL Server tip illustrates how you can ... For instance, in my experience, most DBAs in North America go with the default collation, which is case insensitive. The collation has no effect ...

BR><BR>This machine already has a SQL Server 2005 installation, and it uses the wrong collation (case insensitive/accent insensitive when I need case insensitive/accent sensitive, I think).< ...

Column names can be case-sensitive also. Some DBMSs allow case sensitive column ... are used with SAS/ACCESS and the SQL Procedure Pass-Through Facility. See your DBMS chapter for more information ...