Step into stored procedure - canceled by user

Question

Hi,

I am trying to debug a long stored procedure in Visual Studio 2008. I have followed all the steps on this link:

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

but I still get the same error... 'Canceled by user' and it never hits the breakpoint.

Visual Studio 2008 and SQL Server 2005 are running on 2 different servers and domains although I can see the SQL Server from the PC running Visual Studio.

Any ideas?

Thanks

Answer 1

I think that you are already on the right track, as that article on sql team is exactly what I would have pointed you to. Can you verify that you've read and followed the instructions he points you at:

Setting Up SQL Debugging

Every single time that I've encountered that lame excuse for an error message, I've found it to be a configuration problem of one sort or another.