Message in Profiler

  • Hi Folks,

    I'm running a profile on a prod db and I keep seeing this multiple times in the log:

    Event ID: 17

    User: is a dbo user

    Text:

    network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set language us_english set dateformat mdy set datefirst 7

    It looks like a spit out of the settings for the db? Just wondering what this is and why it is being logged??

    Thanks,

    R.

    Edited by - robby_disco on 05/26/2003 09:19:50 AM

  • This was removed by the editor as SPAM

  • You only see if it you capture the Sessions:ExistingConnections event. Each session can have the settings you're seeing, sometimes you need to know what is active to help you figure out behavior later in the trace.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply