Block new session in a data base

• leonardo_gt

  Old Hand

  Points: 382

  More actions

  May 10, 2010 at 1:48 pm

  #234833

  I need to block the new starts sessions in a database, but also i want to maintain which are currently running some process. Does anyone how to know that?

  This is to restart the sql server services quietly..

  Thanks

• JeremyE

  SSCoach

  Points: 16325

  More actions

  May 10, 2010 at 4:16 pm

  #1165269

  Pause SQL server before restarting it. This will block new sessions but will allow the current ones to finish.