Saturday, 8 October 2016

How to kill/Terminate all running process on Sql Server

alter database current set single_user with rollback immediate;
go
alter database current set multi_user;
go

No comments:

Post a Comment

Table Partitioning in SQL Server

  Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ...