Is there a way to update the dependency information
For example if I create a SP that references a table that does not exist no record will be put in sysdepends. If I later add this table can I update the dependancies to reflect this change?the only way I can think is to run Alter procedure script
in QA, or open the SP in Enterprise Manager and add a
blank line anywhere. This will update the sysdepends table.
>--Original Message--
>Is there a way to update the dependency information?
>For example if I create a SP that references a table that
does not exist no record will be put in sysdepends. If I
later add this table can I update the dependancies to
reflect this change?
>.
>
Tuesday, February 14, 2012
Dependancy Information
Labels:
create,
database,
dependancy,
dependency,
example,
exist,
microsoft,
mysql,
oracle,
record,
references,
server,
sql,
table,
update
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment