How to enable remote debugging in SQL Server 2008 Manamgement Studio

[we|rd0]

I want a debug a SP(Stored Procedure) remotely in SQL Server 2008. But, when I go to Debug--> Start Debugging, I get the error

"Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'TESTSERVER'.Click Help for more information."

I have tried running Management Studio as Admin but it did not work either. Is there any way I can solve this solve this problem? Like I can give all the rights to the user( same as the root user) and solve my problem.

Any video tutorial would be highly appreciated.

[Erland Sommarskog]

Post by we|rd0
I want a debug a SP(Stored Procedure) remotely in SQL Server 2008. But,
when I go to Debug--> Start Debugging, I get the error
"Unable to start T-SQL Debugging. Could not attach to SQL Server process
on 'TESTSERVER'.Click Help for more information."
I have tried running Management Studio as Admin but it did not work
either. Is there any way I can solve this solve this problem? Like I can
give all the rights to the user( same as the root user) and solve my
problem.

It was over ten years ago that I realised that I spent more time on
getting that debugger to work than I gained in productivity. These says,
I only use SELECT and PRINT for debugging. Even when it works, it has
limited value, since you cannot look into tables.