Tag: SLQ

Shrink MSSQL Databases

There are several ways to shrink or truncate your MS SQL databases. One procedure is to run a backup from within the Enterprise Manager. Open Enterprise Manager Expand your SQL Server Group and your Local server Expand Databases Right Click…

Error When Upgrading WSUS 3 SP2

While trying upgrade Windows Server Update Services, WSUS, I experience the following error in the setup log and the install would stop:

2010-01-08 10:37:52 Error MWUSSetup ExecuteQuery: Failed to execute SQL query USE SUSDB IF EXISTS (select * FROM master..sysdatabases WHERE name= N’SUSDB’ AND suser_sname(sid) is null) EXEC dbo.sp_changedbowner N'”DomainName”\administrator’ (Error 0x80040E14)