Monday, December 29, 2014

Generated Script fails when attempting to drop Foreign Key Constraint

First question is whether you were running it on the correct database. Did you select option script USE database to True. Otherwise it will not have USE DBName on top and so if you just open it in a query editor window and execute it it will try to execute it against the default db (or master) which may not be where you have created those tables and constraints originally.


Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page


No comments:

Post a Comment