sp_depends not showing all dependencies
Sybase --- sp_depends when i run for a stored proc A , it doesn't showing all the dependencies. Its missing some stored procedures which are called from inside the parent stored procedure A.
How can this be corrected ?
How can this be corrected ?
Drop and recreate the parent proc.
You’ll sometimes get messages when creating an object that sysdepends won’t be correctly populated. Most often this happens when objects aren’t or can’t be created in a strictly child to parent sequence, or when an object is orphaned after a dump and load to another ASE which doesn’t have a login or some other element of the chain.
The moral of the story is that sp_depends is unreliable and is only ever making a best efforts guess. Don’t rely on it for anything important. This isn’t considered a bug. :/
I don’t know what went wrong in your particular scenario though but dropping and recreating the proc should fix it. If you’re using a recent version you have access to an Oracle-like syntax “CREATE OR REPLACE” which makes some of these things easier.
You’ll sometimes get messages when creating an object that sysdepends won’t be correctly populated. Most often this happens when objects aren’t or can’t be created in a strictly child to parent sequence, or when an object is orphaned after a dump and load to another ASE which doesn’t have a login or some other element of the chain.
The moral of the story is that sp_depends is unreliable and is only ever making a best efforts guess. Don’t rely on it for anything important. This isn’t considered a bug. :/
I don’t know what went wrong in your particular scenario though but dropping and recreating the proc should fix it. If you’re using a recent version you have access to an Oracle-like syntax “CREATE OR REPLACE” which makes some of these things easier.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER