>Yes, if you set the collation to be the case sensitive when you installed your SQL Server. It also could be set for each database.

Yes, but without any change at that level, it worked and not. IAC, it is presently case sensitive. So, a new install will be done to correct that.