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.