DBCC TRACEON 3604

dbaadmdbaadm Posts: 6
edited May 10, 2005 1:12PM in SQL Toolkit Previous Versions
I have build a application based on SQL Toolkit. The application compare a given database to it's snapshot file. But every time the applikacation connect to the SQL Server it's write a entry to the servers event log:

Event Type: Information
Event Category: (2)
Event ID: 17055
Description:
17550 :
DBCC TRACEON 3604, server process ID (SPID) 240.

Since one of the ways to observe server is to monitor their EventLog it's giv noise with information that isn't critical.
Can the trace flag be removed or modified?

I can see that a similar topic has been submited under SQL Compare.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    This warning has to do with the way that SQL Compare handles encrypted objects. Can I get back to you tomorrow with the answer for how to prevent this event from being logged?

    Thanks!
    · Share on Twitter
  • dbaadmdbaadm Posts: 6
    I am looking forward to answer ;-)
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    SQL Server does not allow you to turn off this event. There is a logging level in your database properties page (when you right-click the server in Enterprise Manager) which you can change, but I don't think it will suppress this informational event because of the C2-compliant SQL Server logging.
    · Share on Twitter
This discussion has been closed.