Debugging nested Stored Procedures

Does SQL Server 2000 provide the ability to debug a nested SP or a trigger?
Can a watch be set and when the SP fires regardless of which user initiated
it a debug mode UI be displayed. If SQL Server doesn't provide this
functionality are there any tools that do. Compuware 'DevPartnerDB Debugger'
use to provide this but the product is no longer.
Brent,
With SQL Server 2000 stored procedure debugging, you can step into lower
level code, such as another stored procedure or a trigger.
However, this feature only works from SQL Server Query Analyzer. You must
right-click on the stored procedure and select 'Debug'. This means that
you can only debug your personal execution of the stored procedure and
underlying code.
This means that you cannot have a debug window pop up when some other
persons runs the stored procedure in question. I don't know of a widget to
do this. You can run SQL Trace to trace execution at the statement level,
but this would not give you everything that a debugger does.
FWIW,
RLF
"Brent" <essexbs@.insightbb.com> wrote in message
news:eGTVM3UVIHA.6092@.TK2MSFTNGP06.phx.gbl...
> Does SQL Server 2000 provide the ability to debug a nested SP or a
> trigger? Can a watch be set and when the SP fires regardless of which user
> initiated it a debug mode UI be displayed. If SQL Server doesn't provide
> this functionality are there any tools that do. Compuware 'DevPartnerDB
> Debugger' use to provide this but the product is no longer.
>