Monday, October 29, 2018

Press Ctrl+Alt+a in SQL Server 2016 Management Studio to open the Activity Monitor.

There is also an icon for it in the Standard toolbar that kinda looks like a graph with some thing sitting at its lower right corner. View > Toolbars > Standard ...should unlock this menu/toolbar if you do not see it. There is an "accordion" for Processes inside, and here you may right-click on Processes to kill them. You may kick other users out of the database in advance of making sweeping changes in this manner.

No comments:

Post a Comment