title: If a sql server's server collation is case sensitive and a database is case-insensitive, will queries be case-sensitive or not?
body: <p>If a sql server's server collation is case sensitive and a database is case-insensitive, will queries be case-sensitive or not? I thought that it was supposed to be based on the database rather than the server collation, but having done a short test that seems not to be the case. Anyone know for sure?</p>