System Generated Session ID RRS feed

  • Question

  • I am new to SQL Server, and I must configure/verify that Microsoft SQL Server 2008R2 will only recognize session identifiers that are system generated.
    Tuesday, July 29, 2014 3:17 PM


  • At first, I did not understand your requirement however after googling it I got this similar thread that might help you - article here.

    In the query mentioned in that post, you just have to change the sessionID as follows:

    S.SESSION_ID <= 50

    If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

    Tuesday, July 29, 2014 3:34 PM