trying to attach to a process in debug

I'm in VS2008 trying to Attach to a process... I can attach fine to the Managed Code, however I get an erro开发者_高级运维r when trying to attach to T-SQL it says Access is denied.

How do i resolve that?

---

T-SQL debugging from Visual Studio has a lot of requirements on the server and the client you should review the following the MSDN Documents

Debugging SQL

Setting Up SQL Debugging

SQL Debugging Setup Errors and Troubleshooting

And in particular since you have Access issues

SQL Debugging: Security Issues

How to: Set SQL Server Permissions for Debugging

---

Are you debugging locally or on a remote database? If remote, is the user whose context you are debugging in configured as a login in SQL Server?

If it isn't, you will have to run your debugger with an authorized Windows user.