Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing constraints
Message
 
 
To
25/03/2011 10:45:00
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01504936
Message ID:
01504989
Views:
22
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform