DBCC TRACEON 208

• snikpoh

  SSCommitted

  Points: 1873

  More actions

  November 11, 2003 at 10:15 am

  #358514

  Hi,

  I used to get a handful of these a day on sql 7 and now we are on 2K I get about a hundred. They all come from users connecting directly to the tables via Access - but not on every connection. I can't find anything on BOL for this particular trace and so have no idea - do you?

  Many thanks,

• Jean Maurais

  Right there with Babe

  Points: 737

  More actions

  November 11, 2003 at 1:50 pm

  #481620

  It simply means that the connection has set quoted identifier on.

  Here is a link you can check out on Microsoft's Knowledge Base:

  http://support.microsoft.com:80/support/kb/articles/Q243/3/52.asp&NoWebContent=1

  You can set a trace flag at SQL Server startup to prevent these from showing up in the log.

  JM

  Edited by - jmaurais on 11/11/2003 1:51:00 PM