SQL Server 2008 sp1

asp.net-3.5installationsql-server-2008

When I try to install SQL Server 2008 sp1 on my system, the installer runs and does the prerequisites check, every thing is ok except it says my machine has a pending reboot and won't continue until this is done. I Cold Reboot the machine,run the installer and the same message comes up. So I can't install the sp1 update. Any ideas ?

Info: OS Win XP sp3 x32 , VS 2008 sp1, SQL 2008 standard

Best Answer

The pending reboot issue usually indicates that a previous installation didn't clean up after itself. Look in your registry for this key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
\PendingFileRenameOperations

Remove any values under that key and try the install again.

LEGAL FINEPRINT: export and save, before making changes to the registry...blah, blah, blah...

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith's version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

Sql-server – Installation problem sql server 2008

Found this here: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3762432&SiteID=1

"You can open Regedit, and modify this key"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager" and delete any value in "PendingFileRenameOperations""

Best Answer

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

Sql-server – Installation problem sql server 2008

Related Topic