Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • 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.
0
graphix03
Asked:
graphix03
  • 2
3 Solutions
 
Anthony PerkinsCommented:
Do you have execute permissions on the sp_sdidebug extended stored procedure?
0
 
r_a_j_e_s_hCommented:
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
0
 
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.

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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