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 

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!