• Rune Bivrin (5/2/2013)


    Hugo Kornelis (5/2/2013)


    However, to do some nitpicking:

    1. If I were to try this code on my system, I would get five errors. All system table (*) names are completely lowercase, so everyone who has a server set up with a case sensitive collation will get error messages. (And I think every development server SHOULD be set up with case sensitive collation - developing there and deploying to a case insensitive server is okay, the other word around is a disaster)

    Not necessarily true. If your development server is case sensitive you run the risk of having more than one object with the same name, only with different casing. When deploying on a case INsensitive server it will blow up.

    +1

    Why should you choose CASE SENSITIVE COLLATION?

    Please, do not answer for performance reason!