Debugging procedures in Query Analizer

Question

Debugging procedures in Query Analizer

Omar Bellio

SSC Enthusiast

Points: 135
More actions
August 17, 2005 at 7:53 am

#94594

My problem is (yes, I know... never a solution, but… that’s the forum for… ) as follows:

In an SQL Server Developer Edition installed on Windows XP Pro, the step buttons of the debugger are disabled and I can’t trace step by step a procedure.

It starts, executes the procedure but doesn’t stop, even if I set a breakpoint.

I couldn’t find any configuration issue that addresses to this. Any suggestion will be welcomed.

Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

Are you running QA on the server itself, or over a network? I think I've heard of this happening over a network - can you copy the db to your PC and try debugging it locally?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

Make sure you and the server are running under admin rights. I've had issues when things weren't.

Omar Bellio SSC Enthusiast Points: 135 More actions · Answer 3

Yes, the installation is local to my develop machine, and I have admin rights. Any further idea?

Thanks.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 4

I am having a problem almost just like this one.

How do i log on as another account so that i can debug in the Analyzer.. I have been wondering for awhile why sql would not have a feature like the debugger,, and they do, i just did not know about it.

Any suggections?

Here is the error message that i am receiving.

SP Debugging may not work properly if you log on as ‘Local system asccount’ while SQL Server is configured to run as a service.

You can open Event Viewer to see details

Dam again!

Joseph Fallon SSCommitted Points: 1669 More actions · Answer 5

Omar, I had this problem too - it was fixed by installing SQL Server 2000 Service Pack 3.

Erik, you need to go to Control Panel | Services and double click on the MSSQL service

BuilderBits SSCertifiable Points: 6071 More actions · Answer 6

Ok,

I will try this, because u really, really would like to be able to debug inside the analyzer

Dam again!

BuilderBits SSCertifiable Points: 6071 More actions · Answer 7

There is not -------> Control Panel | Services and double click on the MSSQL service <------------

IN my control panel

Thanks,

Erik

Dam again!

Omar Bellio SSC Enthusiast Points: 135 More actions · Answer 8

Joseph, you were right, SP3 solved the problem.

I also found in the sp3 documentation that debugging functionality is disabled by default prior to sp3, but it may be enabled by running sp_sdidebug and passing the parameter legacy_on

BuilderBits SSCertifiable Points: 6071 More actions · Answer 9

So you got yours to work?

If you do not mind me asking what is the link to the SP3?

Erik..

Are how can i enable the debuggers?

Dam again!