Yesterday I was debugging an
ASP.NET application based on database (MS SQL Server). I was getting a strange error:
EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.
Well store procedure 'sp_sdidebug', enable debugging on SQL Server.
Since this SP is in "master" database, you have to have proper access
and execute rights on this master DB.