How to enable T-SQL debugging in Visual Studio .NET 2005

1. Right click on a user that you want to enable to debug and select a properties.

2. Select Server Roles and check sysadmin role.

3. You may run following query:

4. Open your Visual Studio .NET 2005 and open a Server Explorer.
Then right click on Data Connection and select Add Connection…

5. Then setup db connection.

6. Now expand your db from Visual Studio.net 2005 and right click a stored procedure to debug, then choose step into.

7. Now, you provide inputs for SP.

8. Then finally you are able to debug T-sql in Visual Studio .NET 2005.
Congratulations!!!