I am attempting to step into some SQL from VS2005 Pro SP1, and about half the time, I get the error, "T-SQL execution ended without debugging. You may not have sufficient permissions to debug. Click Help for more information." This is accompanied by some output in the Output window, which comes from within the stored procedure I was attempting to step into. So somewhere in there, VS has actually run my procedure in its entirety... Also, attempting to step into SQL can sometimes cause VS2005 to hang. It does not appear to have a connection with SQL Server when it hangs. SQL Server (2005) and VS2005 are located on the _same_ machine, so I did not expect any domain/security-related issues. (Nor would I have expected that sort of error to be sporadic.) Any ideas would be greatly appreciated. Thanks.
