Changing SQL Server collation to case insensitive from case sensitive?

Viewed 122466

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?

2 Answers
Related