Post reply

what is the Exec_context_ID in sys.dm_os_Tasks?

  • October 24, 2012 at 9:43 am

    #263778

    Is the exec_context_id to do with execution context, when thought of from a security perspective (i.e run a sproc under some other users context) or does it mean something different. All technet says is "

    "Execution context ID that is associated with the task. ", which is not hugely helpful.

    Thanks!

  • October 24, 2012 at 10:08 am

    #1552349

    Here's what MSDN says:

    Execution context identifier (ECID). The execution context ID of a given thread associated with a specific SPID.

    ECID = {0,1,2,3, ...n}, where 0 always represents the main or parent thread, and {1,2,3, ...n} represent the subthreads.

    From: http://msdn.microsoft.com/en-us/library/ms188246.aspx

    Does that help?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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