Debugger? Yah!
-----Original Message-----
From: Davis Diane (DOC-CEN)
[mailto:mssqldba-ezmlmshield-x5564670.[Email address protected]
Sent: Thursday, October 28, 2004 2:41 PM
To: LazyDBA Discussion
Subject: RE: How to see the contents of a stored Proc. from Query
Analyzer
Do you want the debugger?
DD
Diane Davis
Database Analyst
Central Office
717-730-2764
-----Original Message-----
From: Wayne D Barnes
[mailto:mssqldba-ezmlmshield-x82059201.[Email address protected]
Sent: Thursday, October 28, 2004 4:35 PM
To: LazyDBA Discussion
Subject: Re: How to see the contents of a stored Proc. from Query
Analyser
I'd like to add a similar question. I'd like to see what's going on inside
a running stored procedure using Profiler. How do I expose store procedure
activity using Profiler.
Thanks ...
|---------+-------------------------------------------------------->
| | "Joy" |
| | <mssqldba-ezmlmshield-x47188023.[Email Address Removed] | azydba.com> |
| | |
| | 10/28/2004 04:24 PM |
| | |
|---------+-------------------------------------------------------->
>---------------------------------------------------------------------------
---------------------------------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: How to see the contents of a stored Proc. from Query
Analyser |
>---------------------------------------------------------------------------
---------------------------------------------------|
I am trying to see the contents of a stored proc. from Query Analyser. Is
there any stored proc which will let me see the contents of any user SP in
Query Analyser. Please let me know ASAP
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page