當我設法拿來一些數據從一個遙遠的數據庫，我從我的一ASP.NET網服務得到了這個錯誤。 我什么都沒有設法在網上搜尋可能的固定對這個問題，但發現了說服和如此認為出版解決問題的解答。

请注意:，如果您調試您的ASP.NET頁或網服務和手工附有工作者過程，這種解答也許只是有效的。

1. 附上到工作者過程。

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.

Even though this is little off topic I wanted to bring this to you all. I’ve been using Visual SourceSafe and lately Team Foundation Server for change management. Even though Team Foundation Server seems to be a lot better than Visual SourceSafe still I felt a lot better with Subversion. I’ve used that before and it boasts quite a few of features that’s missing on it’s Microsoft counterpart. For those of you who haven’t seen what Subversion means, here is a video from Dan Wahlin that will make you Subversion aware.

Getting started with Subversion and Source Control

Chris Sells, one of my favorite Microsoftie, puts out 6 bulleted list of unpublished tips on getting interviewed at Microsoft. Here are those at a glimpse,

• Your interviewer cares most about 1) how you think and 2) what you feel, so be vocal about both.
• Don’t be afraid to ask clarifying questions.
• Let the interviewer know how you feel about the job.
• Answer questions from your own experiences.
• You have to like us, too.
• Don’t talk about money during the interview.

You can read the details of these bullet points from here. You can also read his “Published Microsoft Interviewing Tips” from here.

tags: Microsoft, Interview, Interview Tips, Tips, Tips and Tricks, Chris Sells