Hi Thanks... This worked 🙂

Hi Adi,

Thanks for your reply. How can we specify the DB in the query, in case if I am using dbOwner role ?

Hi All,

Thank you all for the help.... I am really happy 🙂

Thanks Chris.. thank you very much...

This gives lot of clues ....:)

Thanks 🙂

Thanks Hari.. Thank you very much 🙂

Your procedure is okay. But when we generate script of more than 10 or 15 lengthy procedures, it is getting cut somewhere .. in the middle and bottom..

🙂 Great.. Thanks for your help

Thank you very much for the response.

This was really helpful and it worked.!!

I got a similar solution from another SSC member...

Thanks man...!!!!

It is solved....

Long live SSC Forum.....!!!

Hi ..

Thanks for the reply...

But the problem remains unsolved.. How can I remove the relationships if it is required there... ? Also is it possible to remove the relationship temporarily...

Things are not complicated..

Everything is in straight line only...

I have a table Employees which has EmployeeID As Primary Key.

This table has foreign key reference to more than 100 tables.

When I...

Thanks for the quickie.. 🙂

But this is not possible..