Need Help!!!  
Author Message
Rooney





PostPosted: Thu Jun 17 10:45:21 CDT 2004 Top

SQL Server >> 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,
Linda

SQL Server187  
 
 
Hari





PostPosted: Thu Jun 17 10:45:21 CDT 2004 Top

SQL Server >> Need Help!!! 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




> 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


 
 
Linda





PostPosted: Thu Jun 17 13:56:06 CDT 2004 Top

SQL Server >> Need Help!!! 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
>
>

message

>> 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
>
>
>.
>