Alter Column to become Case Sensitive

SQL Server 2000 (or above) allows individual columns become case sensitive by identifying collation. For example:

ALTER TABLE TblName 
ALTER COLUMN ColName VARCHAR(100) COLLATE Latin1_General_CS_AS NULL

Where _CS_ indicates it is a Case Sensitive column.