Paul Beetge (9/20/2011)
Then it's still not working correctly. It should be able to debug.
Solution please ?
His question was answered- he said he "did not want to debug, just execute...
that said, could be a few different reasons for the error debugging, the most likely cause is the lack of necessary permissions Connecting with system administrator to SQL Server is not sufficient; the Windows login of the Visual Studio user must also be a member of the system administrator role in SQL Server.
If you are having a problem debugging, I'd have a look here: http://social.msdn.microsoft.com/forums/en-US/vsdebug/thread/7937b123-5ffd-48f6-a1de-03e613466a2b/