Post reply

Message in Profiler

  • May 26, 2003 at 9:19 am

    #106083

    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

  • May 29, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • May 29, 2003 at 5:06 pm

    #459122

    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://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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