Debaguear en SQL Server 2005

Esto dice el BOL:

To debug a stored procedure
Open the project used to create the DLL in Visual Studio.

Create breakpoints in the method or function corresponding to the procedure
you want to debug.

Use Visual Studio to create a debug build of a stored procedure DLL.

Deploy the DLL to the server. For more information about deploying the DLL
to the server, see Creating Stored Procedures.

You need an application that calls the stored procedure that you want to
test. If you do not have one ready, you can use the MDX Query Editor in SQL
Server Management Studio to create an MDX query that calls the stored
procedure that you want to test.

In Visual Studio, attach to the Analysis Services process (Msmdsrv.exe).

From the Debug menu, choose Attatch to Process.


In the Attatch to Process dialog box, select Show processes from all users.


In the Available Processes list, in the Process column, click Msmdsrv.exe.
If there is more than one instance of Analysis Services running on the
server, you need to identify the process by the ID of the instance you want
to use.


In the Attach to text box, make sure that the appropriate program type is
selected. For a CLR DLL, click Select, then click Debug these code types,
then click Managed, then click OK. For a COM DLL, click Select, then click
Debug these code types, then click Native, then click OK.


Click Attach.


In Analysis Services, invoke the program or MDX script that calls the stored
procedure. The debugger breaks when it reaches a line containing a
breakpoint. You can evaluate variables in the watch window, view locals, and
step through the code.

Saludos
IIslas


"Jaime Lucci" escribió:

Hola!

Alguien sabe como debaguear en SQL Server 2005? No puedo lograrlo. Antes,
con el 2000, seleccionaba la opcion debug del menu contextual de cada SP,
pero en el 2005 no aparece la opcion.

Gracias y saludos.

Jaime Lucci