Close a session

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  February 19, 2009 at 3:11 am

  #197299

  Hi experts

  Can anyone please tell me the command to close a session after that particular process has finished executing.

  I am not talking about Kill process, i want to close a session.

  Tanx 😀

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  February 20, 2009 at 10:29 pm

  #948105

  Eswin (2/19/2009)

  ---

  Hi experts

  Can anyone please tell me the command to close a session after that particular process has finished executing.

  I am not talking about Kill process, i want to close a session.

  What did you mean by this? Have you got any open transactions? What was your query to look the opened sessions?

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 23, 2009 at 2:14 pm

  #948981

  Eswin (2/19/2009)

  ---

  Hi experts

  Can anyone please tell me the command to close a session after that particular process has finished executing.

  I am not talking about Kill process, i want to close a session.

  session_id in 2005 is an "equivalent" to spid in 2000!

  
  * Noel

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  February 23, 2009 at 3:55 pm

  #949057

  Eswin (2/19/2009)

  ---

  I am not talking about Kill process, i want to close a session.

  Same thing, AFAIK.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]