September 27, 2010 at 3:17 am
Hi,
Is there any way to grant anyone rights to debug in sql server, without having to give them sysadmin rights?
kind regards,
bryan
September 27, 2010 at 11:44 am
So far as I know, Management Studio does not have a debug tool.
Could you rephrase your question?
September 27, 2010 at 11:54 am
From SQL Server 2008 Books Online:
"Configuring and Starting the Transact-SQL Debugger
...
...
The requirements to start the Transact-SQL debugger are 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.
...
...
We recommend that Transact-SQL code be debugged on a test server, not a production server, for the following reasons:
Debugging is a highly privileged operation. Therefore, only members of the sysadmin fixed server role are allowed to debug in SQL Server.
Debugging sessions often run for long periods of time while you investigate the operations of several Transact-SQL statements. Locks, such as update locks, that are acquired by the session might be held for extended periods, until the session is ended or the transaction committed or rolled back.
...
..."
September 27, 2010 at 12:04 pm
You're posting in the wrong forum group. This is the 2005 group and your BOL reference refers to 2008. Try posting there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply