Category: Uncategorized

How to close all connections to a MSSQL database

This script closes all connections to MS SQL database USE master; GO ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE dbName SET MULTI_USER; GO

Hello world!

Welcome to my technical blog, This is a very first post here (and I really hope not the last one). Being in IT industry for a few years now, I realise more and more everyday that having good “knowledge base” is essential for any serious computer professional. Just look here if you do not believe my previous sentence. Although I had […]