Dear All,

How i can enable debugging for sql server 2008 R2?

Which server roles that grant user to debugging on sql server 2008?

Which user mapping that grant user to debug on sql server 2008?

please help.

best regards,

Surbakti

Dear All,

How i can enable debugging for sql server 2008 R2?

Which server roles that grant user to debugging on sql server 2008?

Which user mapping that grant user to debug on sql server 2008?

please help.

best regards,

Surbakti

Hi,

Please refer to the following URL -

https://msdn.microsoft.com/en-us/library/yet1b7by%28VS.80%29.aspx

Hope this will help you.

Dear Shanky_621,

i want debug a SQL query not a stored procedure just an ordinary query with parameter.

when i use admin username i can debug but when i use user username i can debug.

I think its about permission, that's why I'm asking which server roles and user mapping that can use debug.

best regards,

Surbakti

Hi Surbakti,

As described in this article, debugging is a highly privileged operation, only members of the sysadmin fixed server role are allowed to debug in SQL Server. And there are some requirements starting the Transact-SQL debugger as follows.

SQL Server Management Studio must be running under a Windows account that is a member of the sysadmin fixed server roll.

The Database Engine Query Editor window must be connected by using either a Windows Authentication or SQL Server Authentication login that is a member of the sysadmin fixed server role.

There is also a blog  about SQL Server 2008 TSQL debugger for your reference.
http://www.mssqltips.com/sqlservertip/1695/sql-server-2008-tsql-debugger-is-back-in-ssms/

Thanks,
Lydia

If you see your very first question you also asked how can I enable debugging to which I asked what you want to debug.

Debugging requires sysadmin permission and this is mentioned in below article

https://msdn.microsoft.com/en-us/library/w1bhybwz%28v=VS.90%29.aspx

Avoid running debugger on production servers

The minimum security requirement is sysadmin. This is by design from SQL engine security.

https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug