debugging stored procedure

[sandro72]

hi, does someone know if is it possible to debug sql server (7.0) stored
procedures with .net? when i right-click on the stored procedure in the
server explorer i've not the options edit and step into. how can i enable
them?

thanks

 

[Bob Graham]

The only way I know of to debug stored procedures is to run them in Query
Analyzer and set 'Print' statements where you want to see what's happening
in your procedure.

The other thing you can do is to break the procedure down into smaller
parts and see how each segment works.

If you don't have Query Analyzer there may be an equivalent function in
Visual Studio or you could download the trial version of Sql Server. It
times out after 120 days on the actual database but the peripheral tools
keep working.

Bob

 

[Srinivas Kanakapally [MSFT]]

It is possible to debug SQL7.0 stored procedures using Visual Studio .Net,
but you will need to have the Enterprise edition of VS .Net for this
functionality. You most probably have either the Professional or Standard
edition of Visual Studio .Net and hence the reason you cannot see the
options 'Edit' or 'Step Into'.

Thanks!
Srinivas Kanakapally
Visual Studio .Net Data Tools, MSFT

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.