>Our ERP system runs on SQL Server and it's both case sensitive and uses spaces in table and column names. Yes, you have to pay careful attention.
Case preserving is nice. Case sensitive... ouch. Perhaps for those born and grown in unix/linux environments it becomes natural. For us, it hurts.