Re: ERROR ON DEBUGGING A STORED PROCEDURE
From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 05/11/04
- Next message: Vinodk: "Re: Precompile and stay in cache"
- Previous message: Michael Cheng [MSFT]: "Re: Domain Name"
- In reply to: ANDREAMALA: "ERROR ON DEBUGGING A STORED PROCEDURE"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 13:52:46 +0530
I think you are on SQL Server SP3 Patch. Debugging is disabled by default on
install of SP3. Check the SP3 Readme.htm for details on this. There is a
section for the same. You need to run the sp_sdidebug Proc to enable the
same.
Also, I've noticed that you need to run the SP3 on the client from where you
access the SQL Server. This will update all the client tools to the latest
version.
-- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD http://www.extremeexperts.com Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp "ANDREAMALA" <anonymous@discussions.microsoft.com> wrote in message news:0ECFDC7A-3229-455A-B53F-5F07F315DFD0@microsoft.com... > I'M TRYING TO DEBUG A STORED PROCEDURE BUT I OBTAIN THIS ERROR: > Server: messaggio 229, livello 14, stato 5, procedura sp_sdidebug, riga 1 > [Microsoft][ODBC SQL Server Driver][SQL Server]L'autorizzazione EXECUTE è stata negata per l'oggetto 'sp_sdidebug', database 'master', proprietario 'dbo' > > CAN YOU HELP ME? > > GREATINGS > ANDREA
- Next message: Vinodk: "Re: Precompile and stay in cache"
- Previous message: Michael Cheng [MSFT]: "Re: Domain Name"
- In reply to: ANDREAMALA: "ERROR ON DEBUGGING A STORED PROCEDURE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
