Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 QA Debugger cannot debug SP

Author  Topic 

vijeyashobana
Starting Member

9 Posts

Posted - 2008-10-01 : 11:07:12
I'm trying to debug a SP on a remote machine. I've been doing this for over a hundred times now. But now the problem is I get a message
'Debugger interface not installed....and make sure you select Development\Debugger interface'.

I've come across this message before and when I do Exec sp_sdidebug 'legacy on' I can debug. But today even after execing this SP I get the same error msg and I could not debug my SP.

Any ideas/suggestions/guidance/assistance are highly welcome.

Thanks,
VijeyaShobana J

Thanks & Regards

vijeyashobana
Starting Member

9 Posts

Posted - 2008-10-01 : 12:26:04
alright folks. I fixed it. I execed the SPs in the following order:

1. exec sp_sdidebug
2. exec sp_sdidebug 'legacy on'.
3. Closed the Enterprise Manager and opened.

This is what I've done before too but this time I didn't switch between different QA windows. I execed the 1st 2 SPs in the same QA window. I cannot guess why this should be a problem but hey, as long as it works, why bother? :)

Hope this helps someone in need,
Thanks
VijeyaShobana J
Go to Top of Page
   

- Advertisement -