Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Removing constraints
Message
 
 
À
25/03/2011 10:45:00
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01504936
Message ID:
01504989
Vues:
24
>>Take a look at the beginning of this blog post
>>http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/delete-all-data-in-database-when-you-hav
>>
>>As you can see, all identifiers are put in [ ] and also Nikola uses just one command to delete all constraints at once (as Boris suggested also).
>
>Yes, that is probably what it is. But, as I just mentioned in Sergey's message, I just don't understand why it is working as is on the other two servers. IAC, with the [] characters, that should resolve the problem. I will only be able to confirm that next week.

May be there are some test tables in that database.

The simple way to check if the problem is in the table names
select Table_Name from Information_Schema.Columns -- for this database
see if there is something odd here

Then check the same for constraints.
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