Need Help!

Does anyone know if there are dependencies to a table,
after the table is modified, the dependencies don't show
up in the list however all related procedures, triggers,
etc. still exist in the database.
Will this have any impact?
Thank you,
LindaHi,
execute the below command and see dependencies are there
sp_depends <table_name>
This command will not display the objects dependant on other databases.
Note:
For safe execute SP_RECOMPILE <table_name>
Thanks
Hari
MCDBA
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1dcd201c45482$6d8a0520$a101280a@.phx
.gbl...
> Does anyone know if there are dependencies to a table,
> after the table is modified, the dependencies don't show
> up in the list however all related procedures, triggers,
> etc. still exist in the database.
> Will this have any impact?
> Thank you,
> Linda|||Hari,
I saw about 61 dependecies for this one table.
After I added columns to this table, dependencies are
gone 'cause when I run sp_depends I don't see
those dependencies. Even the total no. of record
in sp_depends is minus 61. Is there any way I
can avoid this? How do I restore all dependencies?
All tables, procedures, etc. are there.
How do I link them?
I ran sp_stored_procedures to confirm all procs are
there.
Thanks for your help!
-Linda

>--Original Message--
>Hi,
>execute the below command and see dependencies are there
>sp_depends <table_name>
>This command will not display the objects dependant on
other databases.
>Note:
>For safe execute SP_RECOMPILE <table_name>
>Thanks
>Hari
>MCDBA
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1dcd201c45482$6d8a0520$a101280a@.phx
.gbl...
show[vbcol=seagreen]
triggers,[vbcol=seagreen]
>
>.
>