Re: DBCC Traceon
From: Tudor Sofron (tudor.sofron_at_mydomain.com)
Date: Mon, 10 Jan 2005 09:57:35 +0200
this is one of the links found with google by searching dbcc traceon (8765).
It's pretty well explained. The resons I have use that trace flag are the
same as in the article above.
"Tudor Sofron" <firstname.lastname@example.org> wrote in message
> Hello all,
> I have written a procedure which imports data into SQL Server from MySQL
> using driver 3.51.06. Nothing unusual til now but the fact that the stored
> procedure is using dbcc traceon (8765). So, I grant execute to an ordinary
> user on the procedure, the user can execute it but the procedure throws
> error that the user cannot run dbcc traceon. Does anybody know what
> rights do I have to grant to the users for running dbcc traceon or if
> is some other option instead of using dbcc traceon.