I realize that you and I have just answered a 2 year post but I thought I'd also add my 2 cents.

Make darned sure that you really want a case-sensitive server before you select a case-sensitive collation. I've found that there's actually very little that needs to be case sensitive in most U.S. application (can't speak to requirements of other countries). As a result, I'll select a case-insensitive collation for the server and only make the columns that require case-sensitivity to have a case-sensitive collation at table creation time. You have to be a little careful about how things are used in TempDB when you do that but it's a whole lot easier for a lot of everything else.