Results 1 to 2 of 2

Thread: Can't seem to fix the permissions to debug a Stored Procedure?

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    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,
    Blake

  2. #2
    Addicted Member
    Join Date
    Oct 2008
    Location
    Califorina
    Posts
    235

    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
  •  



Click Here to Expand Forum to Full Width