Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
Kelly
To learn what EM does, run a profiler trace. You will probably find that EM calls a number of stored
procedures. So, you can read the source code for those stored procedures to determine whether you should
consider this a bug and possibly open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
|||Depending on the nature of the table changes EM may create a new table, copy the data, and drop the original table. This process causes the dependency records to be lost. The dependency records can be restored by dropping and creating all the dependent
objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependency records automatically. WT2 and WT3 implement that feature in the same way, but then they diverge into different functionality. You can learn more at this URL...
http://www.sqlservertools.us
"Kelly" wrote:

> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>
|||Tibor,
Thanks for your input.
-Kelly

>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...[vbcol=seagreen]
etc.
>
>.
>
|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...[vbcol=seagreen]
>http://www.sqlservertools.us
>"Kelly" wrote:
etc.
>.
>