where to set up the dependency?

[babeo]

Hi,
I create a new table with "select into...", and set up all permission requirement, and transfer all data from old table into this new table, at the end, I just find out the new table does not have any dependencies, which the old table has at least 5 store procedures dependencies.

I recreate the new table using the second method of generating the SQL code from the old table with transferring all setup and permision, and I check out the new table still does not have any dependencies.

How can I restransfer or set up back the dependencies for my new table?
Thanks

 

[tlbroadbent]

Recompile the stored procedures and views that reference the table.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm