title: Changing SQL Server collation to case insensitive from case sensitive?
body: <p>I've recently installed SQL Server 2008 and I selected collation as case sensitive. I want to make it case insensitive for the entire instance (not for a database in that instance). If I change the collation does it affect any existing databases? if so in what way?</p>