Debug MDX Procedure Based .NET in Visual Studio

转载于 2009-05-30 23:48:00 发布 · 67 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/SmartBizSoft/archive/2009/05/30/1492561.html

本文介绍在Visual Studio中调试MDX过程的方法。通过将项目附加到Analysis Service进程(msmdsrv.exe)，可以轻松加载所需的组件并设置断点进行调试。确保勾选了项目属性面板中的“启用SQL Server调试”选项。

It's really a piece of cake to debug MDX procedure in Visual Studio. It will be done just in only a few steps. In Visual Studio 2010(the same to VS2005 and VS2008), you should attach the MDX procedure project to the Analysis Service process(msmdsrv.exe), and then the assemblies which are needed will be loaded automatically. The specific MDX procedure will also be loaded by Analysis Service. Before debugging the procedure, at least one break point should be set in the procedure. Run the MDX code contain the procedure to start the debug. The execution flow will jump into Visual Studio and stop at the break point that is set before. There is one important tip, that is the checkbox of 'Enable SQL Server debugging' should be checked. The checkbox is in the debug tab of project property panel(just as shown below).