Memo from Julian Fox of PricewaterhouseCoopers
-------------------- Start of message text --------------------
Hello all.
Can anyone tell me of the most reliable way to check object dependencies,
in particular which stored procedures are calling which other stored
procedures? There are two methods I use:
1. sp_depends: I am aware that this can be very inaccurate, according to
the order in which stored procedures have been created.
2. I query syscomments directly to check the text of procedures for the
occurrence of a particular string. Although this method is better than
using sp_depends I know that it is not completely reliable, i.e. a match
might be missed if the searched-for string occurs across a row-break.
Has anyone any other suggestions for how to check for these dependencies?
Thanks.
Julian.
--------------------- End of message text --------------------
This e-mail is intended only for the person to whom it is
addressed. If an addressing or transmission error has
misdirected this e-mail, please notify the author by replying to
this e-mail. If you are not the intended recipient you must not
use, disclose, copy, print or rely on this e-mail.
The principal place of business of PricewaterhouseCoopers and
its associate partnerships is 1 Embankment Place, London
WC2N 6RH where lists of the partners' names are available for
inspection. All partners in the associate partnerships are
authorised to conduct business as agents of, and all contracts
for services to clients are with, PricewaterhouseCoopers. The
UK firm of PricewaterhouseCoopers is authorised by the
Institute of Chartered Accountants in England and Wales to
carry on investment business. PricewaterhouseCoopers is a
member of the world-wide PricewaterhouseCoopers
organisation.
PricewaterhouseCoopers may monitor outgoing and incoming
e-mails and other telecommunications on its e-mail and
telecommunications systems.
----------------------------------------------------------------
Visit our website http://www.pwcglobal.com
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
MS Sql Server LazyDBA home page