How to debug a CLR proc in VS2008?

Question

Hi,

I have written a CLR proc in VS2008 and deployed to SQL 2005 DB.

I have set mode to debug and made sure my .sql script is set to run my proc.

Have deployed with permission level to External and set db to be trustworthy on.

But when I run the breakpoint is not hit and nothing seems to be happening.

What am I missing please???

Malcolm

Answer 1

This MSDN forum thread suggests among several things to try restarting the Remote Debugger (msvsmon.exe) on the SQL machine.

EDIT: Have you set up remote debugging of a SQL CLR Stored Procedure as per this article?