While debugging a CLR Stored Procedure VS2008 is giving error like 'cancelled by user'

Question

please any one help me

while debugging a CLR sp am getting error like "cancelled by user"

i think i need to enable something?

Answer 1

See this thread and this KB article for various ideas.

In my case (Windows XP, local debugging) it mysteriously helped to turn off "Deploy code" option in the VS project.

P.S. To help Google find it: actual error is (misspelled) "canceled by user".