INF: "DBCC TRACEON (208)" Messages in the Error Log When Using MSQuery

• Microsoft SQL Server versions 7.0, 6.5

SUMMARY

When running Microsoft Query (MSQuery), you may receive the following message in the SQL Server error log or Windows NT Event Viewer Application Log when you attempt to create a new query or open an existing query:

99/03/04 12:42:07.28 spid10 DBCC TRACEON 208, SPID 10

MORE INFORMATION

DBCC TRACEON (208) simply means SET QUOTED IDENTIFIER ON. Therefore, these messages do not cause any harm and can safely be ignored. The SQL Server ODBC driver puts the DBCC TRACEON (208) message into the connection string whenever it determines that MSQuery is connecting to SQL Server. This only occurs in a connection between Microsoft Query and SQL Server; for example, if you were to use Microsoft Access instead of Microsoft Query, you would not see these messages in the error log.

If you want to prevent these messages from appearing in the error log, you can use trace flag 2505 as a startup parameter. To set trace flag 2505, perform either of the sets of steps below, depending on the version of SQL Server you are using:

SQL Server 7.0

1. In SQL Server Enterprise Manager, right-click the server name and click Properties on the shortcut menu.



2. On the General tab, click Startup Parameters.



3. Add a new parameter as -T2505.

SQL Server 6.5

1. In SQL Enterprise Manager, right-click the server name click Configure on the shortcut menu.



2. On the Server Options tab, click Parameters.



3. Add a new parameter as -T2505.

Additional query words: errorlog

Keywords : SSrvErr_Log kbSQLServ650 kbSQLServ700
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbinfo