Re: Debugging a stored procedure
From: oj (nospam_ojngo_at_home.com)
Date: 11/16/04
- Next message: avnrao: "Re: Performance Issue"
- Previous message: oj: "Re: detach a db"
- In reply to: Mike: "Debugging a stored procedure"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Nov 2004 00:25:19 -0800
You want to check to see if your files' versions are as listed in kb 839280.
If you think you need the hotfix, you will have to contact MS PSS directly
to acquire such. There is no cost for getting the hotfix. Though, you will
need to provide a credit card # to get to technical support. The support
engineer should reverse the charge and give you the hotfix.
"Mike" <noone@hotmail.com> wrote in message
news:OuV1p%235yEHA.2676@TK2MSFTNGP12.phx.gbl...
> SQL Server 2000
>
> Hi.
>
> I'm trying to set up remote debugging for my SQL Server, so I can step
> through from within VS.NET. The application is running on my PC, while
> the server is on another PC on the same LAN segment. The error I get is:
>
> "Cannot debug stored procedures because the SQL Server database is not
> setup correctly or user does not have permission to execute
> master.sp_sdidebug. Run SQL Server setup or contact database
> administrator."
>
> To try and correct this, I have followed the instructions given here:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvid/html/msdn_storedproceduredebugtech.asp
>
> All files mentioned are in place and registered, and Everyone has access
> to the master.sp_sdidebug procedure. But I still get the error message
> when I try to debug from within VS.NET. An error is appended to the
> application error log that looks like this:
>
> Error: 504, Severity: 16, State: 1
> Unable to connect to debugger on TESTSVR1 (Error = 0x800706ba). Ensure
> that client-side components, such as SQLDBREG.EXE, are installed and
> registered on MIKE. Debugging disabled for connection 71.
>
> The components mentioned are indeed installed. This page here tells me
> there may be a bug in WinXP SP2 which breaks SP debugging, but it doesn't
> give a link to the hotfix, saying we have to contact Microsoft to get it
> (???):
>
> http://support.microsoft.com/kb/839280#kb4
>
> So I'm really not sure if it is the WinXP SP2 bug causing this, or if it's
> just that I haven't set the server up correctly. Does anyone know of a
> solution to this problem, or perhaps even give me a link to the hotfix, as
> I don't want to have to have to negotiate a support contract with
> Microsoft just so they'll take my call.
>
> Cheers,
>
> Mike
>
- Next message: avnrao: "Re: Performance Issue"
- Previous message: oj: "Re: detach a db"
- In reply to: Mike: "Debugging a stored procedure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
