'SQL - How to pause or stop running queries so that an important queries is started and completed successfully

There is a database instance containing a couple of databases along with bunch of tables, Views, SP, etc.

I am wondering what is the best way to pause any currently running queries as well as new queries and at the same time allow certain important queries to run successfully and completely. Only after that all the paused queries as well as other new queries starts and continues.

Notes:

  • killing session is ruled out as it involves dbo privileges.
  • Anything without dbo privileges?
  • all kinds of access is done to execute the queries like using sql ID, AD Groups, excel, access, C#, java, macros, etc. So there must be a way to pause queries coming from these connnections.
sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions