T-SQL Debugger

Posted on 2005-04-18
Last Modified: 2012-08-13
Has anyone use the T-SQL Debugger on SQL Server 2000?
If so, do you have the same problem as I do?

1. I Open the QAnalyzer and connect to the database.
2. I find the selected stored procedure that I want to debug.
3. I right-clicked the SP and choose Debug from the pop-up menu.
4. QA then prompt me to supply the parameters for the SP.
5. THen for each parameter in teh list I typed their value.
6. then I clicked to Execute.

WEll, the T-SQL Debugger opens but it never allow me to
step through -- all the step debug are disabled for some reason
after the SP was executed.  And there was no yellow arrow
to show me the code to be execute next.

any idea why it behaves this way? thanks much.
Question by:graphix03
    LVL 75

    Assisted Solution

    by:Anthony Perkins
    Do you have execute permissions on the sp_sdidebug extended stored procedure?
    LVL 3

    Accepted Solution

    Basically if u want to debug the TSQL, the database should not be in remote location (ie) DB should be in local host, then only u can perform debugging process.

    can u pls tell r u connecting with remote DB or from local host.if ur DB is in remote & still u want to debug then copy the remote DB into ur local host & do the debug process, then sync. with the remote Database...

    it may solve ur issue

    Author Comment

    acperkins - Yes, i have execute permission on the xsp.

    rajesh - Yes, I'm connectiong to local host db.

    Thanks much both for your input.
    I am just gonna use the visual's debugger.
    It works just fine. I just cannot debug from the QAnalyzer.

    LVL 75

    Assisted Solution

    by:Anthony Perkins
    >>I am just gonna use the visual's debugger. <<
    For the record, this uses internally the same components.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    737 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

    19 Experts available now in Live!

    Get 1:1 Help Now