Case Sensitivity is controlled through the database collation. If needed you can change the database collation via the ALTER DATABASE Command to switch to a case insensitive collation. This will however change the way your unique indexes and constraints work.
There is no switch to enable/disable case sensitivity for a specific T/SQL script or connection.
REGISTER or login: