I have a SQL Server with several databases. I want for one of these databases to be case sensitive to names of variable and for others to not.
I need to change settings so I could run this script without errors
DECLARE @A int
DECLARE @a int
How can you change one database to be case sensitive (for its variable names), while allowing other databases on the instance to be case insensitive for variable names?