I got this error from one of my ASP.NET web services when I tried to fetch some data from a remote database. I tried searching online for a possible fix to this issue but found none to be convincing and so thought of publishing the solution that resolved the issue.

Please note that this solution may only be effective if you are debugging your ASP.NET page/web service and are manually attaching the worker process.

1. Attach to the worker process.

2. With the aspnet_wp.exe highlighted hit the “Select…” button at the top right hand side.

You will get the “Select Code Type” dialog with the “Automatically determine the type of code to debug” selected. Now for ASP.NET to use the “Managed” code type by checking the “Managed” checkbox.

Try it again and it should work without the “EXECUTE permission denied on object ’sp_sdidebug’, database ‘master’, owner ‘dbo’.” error.

Hope it helps. Let me know of any issues or alternate solutions in comments.

Ever wonder how to write comments within an aspx file? <!– –> won’t cut it as it gets processed on the server side and the resulting HTML will contain the commented code as processed. Enter, <%– –%>. There are 2 ways you can truly comment on an aspx file.

One way. for example,

<%–

Anything within this block will not be parsed/handled by ASP.NET.

<asp:TextBox runat=”server”></asp:TextBox>

–%>

And here is the other visual way of doing it,

Hope it helps.

Ever wonder how you can change the default web browser used in Visual Studio 2005 IDE? It’s pretty simple.

• Right click on any .aspx file on your IDE’s Solution Explorer
• Click on the “Select With…” menu option
• In the dialog that pops-up select the browser that you want the IDE to be defaulted with. If your browser is not listed you can add your browser to the list
• Click on the “Set as default” button to make the selected browser as the default browser for the IDE

And that’s all to it to set the default browser for your Visual Studio 2005 IDE.