Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 21st, 2005, 07:05 PM
Registered User
 
Join Date: Aug 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default sql debugger

Hello.

I am having problems running t-sql debugger in query analyzer. Every time I try to debug a stored procedure, it gives a message saying "The debugger interface is not installed. Please re-run setup, select 'add components to your existing installation and make sure you select 'Development Tools/Debugger Interface''...

I tried to re-run setup, but it shows the debugger as being installed. Next, I started working on the steps in 'Troubleshooting the Transact-SQL Debugger' in the Book On-line. While trying to register the file sqldbg.dll (regsvr32 sqldbg.dll) I received an error message stating "LoadLibrary ("sqldbg.dll") failed. The specified module could not be found."

Any help is greatly appreciated. Thank you, D K Spivey
 
Old January 12th, 2006, 11:07 AM
Authorized User
 
Join Date: Sep 2004
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Lalit_Pratihari
Default

Hi,

First, for registering a component into your system you should have administrative rights.

Secondly, If you have SQL server installed in your machine (local) then right click the server on EM --> click Properties --> click security tab and click the "This account" option button and give a account userid/pwd.

Hope this works.

Thanks,
Lalit





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with debugger dhavaldesai VS.NET 2002/2003 0 August 10th, 2008 01:36 AM
Debugger warning thillai Visual Basic 2005 Basics 1 April 4th, 2008 08:50 AM
Debugger error on-qsoft VS.NET 2002/2003 3 May 17th, 2007 08:56 PM
Help! Script Debugger! Boker BOOK: Beginning ASP 3.0 2 February 27th, 2007 07:28 PM
SQL Server Transact-SQL Debugger DMK SQL Server 2000 0 May 19th, 2005 01:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.