• Customer Support


    (800) 247-9045

  • Email Us


    support@bisconsultants.com

  • Online Remote Support


    BIS Help.me

  • IT Support After-Hours


    (800) 247-9045, PRESS 4

Author Archive

kill remote sql connections

USE master 
GO 

SET NOCOUNT ON 
DECLARE @DBName varchar(50) 
DECLARE @spidstr varchar(8000) 
DECLARE @ConnKilled smallint 
SET @ConnKilled=0 
SET @spidstr = '' 

Set @DBName = 'DB_NAME' 
IF db_id(@DBName) < 4 
BEGIN 
PRINT 'Connections to system databases cannot be killed' 
RETURN 
END 
SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; ' 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 

IF LEN(@spidstr) > 0 
BEGIN 
EXEC(@spidstr) 
SELECT @ConnKilled = COUNT(1) 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 
END 

Dell mass driver and firmware update tool

Dell driver and firmware update tool

Download the four ISO file segments to a new, empty folder.

Open a command prompt and navigate to that directory where the 4 ISO files are saved.

Run the following command to combine them into one large ISO file.

                copy /b om* om640_suu_a00.iso

Burn the large newly created ISO fie to  a DVD.

© Copyright by BIS Consulting l Farmers Branch, TX l Simplifying IT and GIS for Government Agencies - All rights reserved.