Results 1 to 3 of 3

Thread: DBCC TRACEON 208 in SQL server log

  1. #1
    Join Date
    Aug 2003
    Location
    BS. AS. Argentina
    Posts
    12

    DBCC TRACEON 208 in SQL server log

    Hello I'm new here.
    I need help with this:
    In Sql server log appears some messages like this:
    DBCC TRACEON 208, server process ID (SPID) 136.

    my Server is a cluster SQL2000 SP3.

    Can I have a problem? or is only a message from Query analizer likes occur in SQL7?

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Nothing to worry about.

    It appears every time a stored procedure or sql script sets
    QUOTED_IDENTIFIER to ON.

    If you want to disable it you can start sql server with trace flag

    -T2505

  3. #3
    Join Date
    Aug 2003
    Location
    BS. AS. Argentina
    Posts
    12
    Thanks !!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •