Solved

error msg 229 debugging an sp.

Posted on 2002-05-16
2
597 Views
Last Modified: 2010-05-18

Greetings.

I am using query analyzer to try to debug some stored procedures in a schema. The database tables and procedures were created logged in as sa, and are owned by dbo.
I am running ms sql server 2000
When I try to debug the procedure in query analyzer logged in as a user who is the owner with data_read and data_write rights, I get the below error message (229).
If I am logged in as sa, I do not and can debug the script.

Is there some "right" I can give the user to debug stored procedures? Is this a general problem with sp_sdidebug, or a problem with the way I am accessing my database?

Thanks for any assistance,
Jeff

Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.
0
Comment
Question by:kishj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 5

Expert Comment

by:spcmnspff
ID: 7014364
0
 
LVL 5

Accepted Solution

by:
spcmnspff earned 50 total points
ID: 7014389
After looking a little further.  No matter which debugging client your using, the only user who can execute sp_sdidebug is SA since it resides in the master database.  If you want to allow other users to debug, you'll have to add them to the master db and grant execute on sp_sdidebug.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question