WSUS Hacks

Install SQLCMD Utility from this link Get SQLCMD

Download and Install SQL Server Management Studio (SSMS)

Connect to Windows Internal Database

\\.\pipe\Microsoft##WID\tsql\query

Set BITS Download Priority to fix download errors like

update tbConfigurationC set BitsDownloadPriorityForeground=1

Set WSUS DB in Multi user Mode

--
select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = 'SUSDB'
go
--Kill the spid from above output
kill 5x
--
ALTER DATABASE SUSDB
SET MULTI_USER

Posted

in

by

Tags: