Post reply

View Connections in DMV instead of Profiler

  • May 25, 2012 at 4:17 am

    #258634

    Hi all,

    Im looking the isolation level of a server and opened profiler on a users connection which showed there network settings (Below)

    -- network protocol: TCP/IP

    set quoted_identifier on

    set arithabort off

    set numeric_roundabort off

    set ansi_warnings on

    set ansi_padding on

    set ansi_nulls on

    set concat_null_yields_null on

    set cursor_close_on_commit off

    set implicit_transactions off

    set language us_english

    set dateformat mdy

    set datefirst 7

    set transaction isolation level read committed

    Does anyone the DMV to view this info for all the current connections?

  • May 25, 2012 at 4:18 am

    #1493031

    sys.dm_exec_sessions will give you that information, except numeric_roundabort, cursor_close_on_commit and implicit_transactions, just digging into where these would be.

  • May 25, 2012 at 4:22 am

    #1493032

    thanks sir that's perfect!

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

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