Debug Stored Procedures for MS SQL Server

Posted on 2004-11-10
Last Modified: 2010-04-17
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?
Question by:AshaRRichardson
    LVL 3

    Accepted Solution

    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.

    Author Comment

    Thank you.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
    A short article about problems I had with the new location API and permissions in Marshmallow
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now