Enabling T-SQL Debugger in SQL Server Management Studio (SSMS)

To the best of my knowledge, the debugger is available in all editions of the Microsoft SQL Server, except the Express edition. Hence, if you are not able to see the T-SQL Debugger in your SSMS, most probably,  you are using the SSMS that comes with the Express edition.

If you can see the debugger, but are not able to debug a T-SQL query, it is important to note that not everyone is allowed to debug T-SQL code. This is because, T-SQL Debugging is a highly-privileged operation. To enable the T-SQL debugger in SSMS, the following must be true:

    The user context under which the SSMS is running must be a member of the sysadmin fixed server role
    The user must be connected to the SQL Server using a user who is member of the sysadmin fixed server role

Until we meet next time,

Read more: Beyond Relational
QR:

Posted via email from Jasper-net