Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Case sensitive database instance Expand / Collapse
Author
Message
Posted Wednesday, May 6, 2009 8:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 282, Visits: 1,098
Hi All,

Just noticed on an instance of a customer database, I have noticed that objects (databases and table objects all seem to be Case sensitive). Select * from Sysobjects would fail, whereas Select * from sysobjects works fine.

Is there any reason for this, the same applies to database names as well.

Cheers
Post #711166
Posted Thursday, May 7, 2009 7:00 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:08 AM
Points: 4,427, Visits: 4,179
Sounds like the server has been installed with a case-sensitive collation.

Run SELECT SERVERPROPERTY('Collation') to check.


Markus Bohse
Post #711990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse