Re: DBCC Traceon
From: Tudor Sofron (tudor.sofron_at_mydomain.com)
Date: 01/10/05
- Next message: cy: "Re: Basic Server Roles (security) question"
- Previous message: Lars Bonnesen: "Re: SQL fails after SP3a has been applied. Slammer?"
- In reply to: Tudor Sofron: "DBCC Traceon"
- Next in thread: Andrew J. Kelly: "Re: DBCC Traceon"
- Reply: Andrew J. Kelly: "Re: DBCC Traceon"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 10 Jan 2005 09:57:35 +0200
Hi
this is one of the links found with google by searching dbcc traceon (8765).
http://www.torroid.com/article11119.html
It's pretty well explained. The resons I have use that trace flag are the
same as in the article above.
Thanks,
Tudor
"Tudor Sofron" <tudor.sofron@mydomain.com> wrote in message
news:O4Z7jZn9EHA.1544@TK2MSFTNGP11.phx.gbl...
> 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
> the
> error that the user cannot run dbcc traceon. Does anybody know what
> specific
> rights do I have to grant to the users for running dbcc traceon or if
> there
> is some other option instead of using dbcc traceon.
>
> Thanks,
> Tudor
>
>
>
- Next message: cy: "Re: Basic Server Roles (security) question"
- Previous message: Lars Bonnesen: "Re: SQL fails after SP3a has been applied. Slammer?"
- In reply to: Tudor Sofron: "DBCC Traceon"
- Next in thread: Andrew J. Kelly: "Re: DBCC Traceon"
- Reply: Andrew J. Kelly: "Re: DBCC Traceon"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
