IT Knowledge

Archive for the ‘SQL Server things’ Category

To quickly check why your MSSQL 2000/2005 database is giving errors run

dbcc checkdb (database_name) with data_purity
go

then to fix it, run the following

dbcc checkdb (database_name, repair_rebuild) with data_purity
go

The repair_rebuild and data_purity are supposed to be written like that, don’t change them!. It might take some time to process, specially on a bit slower system.

Problem

After installing SQL Server 2005 on your windows 2003 SP2 server you run windows update, find a whole collection of SQL related updates, including SP2 for Visual Studio. However you find that you cannot install it.

Reasons

Event ID 1008

The installation of C:\WINDOWS\Installer\473946c.msp is not permitted due to an error in software restriction policy processing. The object cannot be trusted.

Event ID 11718

Product: Microsoft Visual Studio 2005 Premier Partner Edition – ENU — Error 1718.File C:\WINDOWS\Installer\473946c.msp did not pass the digital signature check. For more information about a possible resolution for this problem, see http://go.microsoft.com/fwlink/?LinkId=73863.

Event ID 1023

Product: Microsoft Visual Studio 2005 Premier Partner Edition – ENU – Update ‘Microsoft Visual Studio 2005 Team Explorer – ENU Service Pack 1 (KB926601)’ could not be installed. Error code 1603. Additional information is available in the log file.

Solution

Install the hotfix for Windows Server 2003 KB925336.

However, for some unclear reason not all installations require this patch