Trying to set up debugger to use in Visual studio, want to use stored procedures to run through managed code. Want to debug. Changed to compatibility level form 80 to 90 as required. Gave developers who need debugging capabilities administrtor and sysadmin privs on the SQL SERVER 2005 database. From Visual Studio attempt to step into stored produre from either database explorer or directly from Visual studio environment from within the Sql Server Project both resulst in the error message:
Unable to start the T-SQL Debugging. Could not attach to SQL Server process on .....db name....
I have been going through MSDN - and it I have gone through all my permissions .. I am at a loss as to why it is not working - Can anybody help with this - Also, if using debugger on stored procedures will it cause all other gtreads on teh server to be disconnected? And does anybody have any experience with using managed code within stored procedures - do you find it causes the server to hang at all? Can the SDK to run these be 1.0 - I am developing in v 2.0 - But believe the production may only be 1.0..
Any help or commenst would be much, much appreciated!