Need permission to run DBCC Traceon | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Need permission to run DBCC TraceonOne of my SQL users needs to run DBCC traceon command. That command requires sysadmin permission to run. But I do NOT want to grant this user as sysadmin. Are there any other way to make this user run such command?
Thanks for help,
If you cannot grant the user sa rights, perhaps the user can give you the script and you can run it for him and give him back the results.
YOu can take EXECUTE AS privileges in SQL 2005, though.
Thanks for the good recommendation!