Trace Flag 3659


Many setup scripts for SQL Server include the 3659 trace flag, but I could not find official documentation that explains exactly what this flag means.
After a lot of research, I found a reference to this flag in a script called AddSelfToSqlSysadmin, written by Ward Beattie, a developer  in the SQL Server product group at Microsoft.

The script contains a line which suggests that this flag enables logging all errors to errorlog during server startup. I’m unsure of what kind of errors are not logged without setting the flag, but I didn’t find any further reference. The BOL page for Trace Flags doesn’t list this one, so if you happen to know something more, feel free to add a comment here.

Advertisements

Posted on May 20, 2011, in SQL Server and tagged , , . Bookmark the permalink. 9 Comments.

  1. Thanks. I’m following instructions (to change server collation) which include this trace flag with no explanation as to why.

    Good to know what it does!

  2. This flag is, to the best of my knowledge, typically used when running SQL Server interactively to perform some type of maintenance that requires single user mode. By default not all possible messages are always logged. Especially informational messages. For example a message stating a given operation completed successfully may not appear. If you need to know when that operation finished (maybe so you can shut down and restart normally) you need to enable such messages with this flag.

  1. Pingback: SQL Server Trace Flag List | Senior DBA

  2. Pingback: SQL Server Trace Flag List – Updated | Senior DBA

  3. Pingback: Updated: Microsoft SQL Server Trace Flag list | SQL Service

  4. Pingback: SQL Server Trace Flag List – 2330 Update | Senior DBA

  5. Pingback: SQL Server Trace Flag List – Senior DBA

  6. Pingback: SQL Server Trace Flag List – Technology News and Information by SeniorDBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: