SQL Server 2005 General DBA Questions

Re: Need permission to run DBCC Traceon

georgej — Fri, 10 Aug 2007 21:21:54 GMT

Thanks for the good recommendation!

Re: Need permission to run DBCC Traceon

satya — Fri, 10 Aug 2007 13:20:36 GMT

YOu can take EXECUTE AS privileges in SQL 2005, though.

Re: Need permission to run DBCC Traceon

ndinakar — Thu, 09 Aug 2007 22:37:48 GMT

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.

Need permission to run DBCC Traceon

georgej — Thu, 09 Aug 2007 21:38:48 GMT

One 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,

George