Kill User Secession

• RGP

  SSCarpal Tunnel

  Points: 4381

  More actions

  July 17, 2008 at 1:22 am

  #189697

  Hi,

  Any one has a script to identify and kill a specific user secession against a database. I have to restore a database on a daily basis.

  Thanks,

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  July 17, 2008 at 4:35 am

  #844258

  [font="Verdana"]Checkout the script below

  Kill all DB Connections/SPIDS[/font]

  Regards..Vidhya Sagar
  SQL-Articles

• RGP

  SSCarpal Tunnel

  Points: 4381

  More actions

  July 17, 2008 at 5:29 am

  #844283

  thanks!!