-
Jun 20th, 2014, 09:16 AM
#1
Thread Starter
PowerPoster
Can't seem to fix the permissions to debug a Stored Procedure?
I'm using SQL Server 2008 and I'm using the SSMS to try and debug one of my SP's. After I set my breakpoint and click the "Debug" button...I get the following Error Message. So, my boss (he's not a DBA), can't seem to fix it. We both think that it's just a matter of giving my User admin privileges but that doesn't seem to work. Any ideas?
Thanks,
-
Jun 20th, 2014, 04:13 PM
#2
Addicted Member
Re: Can't seem to fix the permissions to debug a Stored Procedure?
You need to have "execute" permission for the sproc. Take a look at the link it will show you how to add your user to be able to execute the sproc.
http://msdn.microsoft.com/en-us/libr...=sql.100).aspx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|