Search
  • Filip Holub

Kill all connections on DB by Cursor


This will be very short post, but for somebody can be very instructive and inspirational.

If you want to kill all connections of one database and if you tired of killing each connection, can you use this Cursor for killing all connections on Database.

For this example I chose AdventureWorks2016CTP3 database, ass you can see below:

I hope that this article has helped!


674 views
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon