How to debug CLR SP using Visual Studio 2005?

Ok I got it.

I have to manually load .PDB as well:

CREATE ASSEMBLY ExecuteExternalReturnTable

FROM '<...>\ExecuteExternalReturnTable\bin\Debug\ExecuteExternalReturnTable.dll'

WITH PERMISSION_SET = UNSAFE;

ALTER ASSEMBLY ExecuteExternalReturnTable ADD FILE

FROM \'<...>\ExecuteExternalReturnTable\bin\Debug\ExecuteExternalReturnTable.pdb'

Then I can attach to SQL Server and my breakpoints will work.

AlexeyYeltsov-MSFTTAPcustmr at 2007-10-2 >