• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Debug Stored Procedures for MS SQL Server

Dear Experts, I read about the t-sql debugger that goes with visual studio.  I don't have visual studio.  Is there any other debugging tools that will work with Enterprise manager tools or Windows xp?
0
AshaRRichardson
Asked:
AshaRRichardson
1 Solution
 
CanadeanCommented:
You can debug a stored procedure from Query Analyzer, right click the SP and choose debug, make sure you have the latest patches on the server and client or it may fail.
XP SP2 seems to cause the debugger to fail too sometimes.
0
 
AshaRRichardsonAuthor Commented:
Thank you.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now