Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:
DECLARE @A int
DECLARE @a int
How can you change one database to be case sensitive (while other databases will be case insensitive)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!