alter database current set single_user with rollback immediate;
go
alter database current set multi_user;
goSaturday, 8 October 2016
How to kill/Terminate all running process on Sql Server
Subscribe to:
Comments (Atom)
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 ...
-
Global .asax file- <%@ Application Language = "C#" %> <script runat= "server" > void...
-
Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ... -
SELECT T.name AS [TABLE NAME], I.rows AS [ROWCOUNT] FROM sys.tables AS T INNER JOIN sys.sysindexes AS I ...