I have only intermittent success with debugging CLR stored procs. Sometimes
it works, and sometimes it does not.

When debugging does not start, the output ends at the line:
Auto-attach to process '[516] sqlservr.exe' on machine 'dcnr-ait669sell'
succeeded.

The visual studio still shows running, but it never gets to a breakpoint and
never shows another line on the output. Processor usage is zero.

To start debugging, I have to restart SQL Server, restart the Visual Studio,
and (probably) restart the machine. Essentially, I just mess with things
until it starts. I have seen it start after a long while when I just let it
sit, but I have let it sit for several hours without starting.

Any suggestions will be appreciated.