Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Case insensitive database on case-sensitive server
Message
 
 
À
13/01/2011 19:05:15
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01496098
Message ID:
01496100
Vues:
55
>Recently ran into problem at customer site where a database built with case-insensitive was attached to server configured with case sensitive as the default. Now we're getting a errors left and right with scripts and such because of non-matching case on identifiers. Any suggestions aside from having to edit of all the scripts (case wasn't always consistent due to several people being involved) to have consistent case, and all SQL-passthru within application to be similarly consistent (again, because several people were involved, we didn't always have consistency in case) ?

I agree with Michel. The only solution is either re-install or have everything match (all identifiers be in right case).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform