私は私のASP.NET網サービスの1つから私が遠隔データベースからのあるデータを取って来ることを試みたときにこの間違いを得た。 私はこの問題に可能な苦境をオンラインで捜すことを試みなかったし、説得力をこめてであることをどれも見つけ、そして問題を解決した解決の出版についてそう考えた。

以下の事項に注意して下さい:この解決はあなたの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