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

T-SQL Debugger

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.
  • 2
3 Solutions
Anthony PerkinsCommented:
Do you have execute permissions on the sp_sdidebug extended stored procedure?
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
graphix03Author Commented:
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 studio.net's debugger.
It works just fine. I just cannot debug from the QAnalyzer.

Anthony PerkinsCommented:
>>I am just gonna use the visual studio.net's debugger. <<
For the record, this uses internally the same components.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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