Hirushan De Silva

1. Execute the below T-SQL query to verify the current SQL Server 2008 Service Pack Information.

SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'
GO




2. Using Add or Remove Programs, Database Administrators can Uninstall SQL Server 2008 Service Pack 1 (SP1). In Add or Remove Program select the Show Updates check box and then choose Service Pack 1 for SQL Server 2008 which comes under Microsoft SQL Server 2008 and click the Remove button to begin the un-installation process.



3. This will open up the Uninstall Service Pack 1 for SQL Server 2008 screen as shown in the snippet below. Once all the prerequisite checks are successful, click Next to continue with the un-installation process.



4. In Select Features screen you can choose the feature which you want to remove the update. Click Next to continue with the un-installation process.



5. In Check Files in Use screen, the un-installation wizard actually checks for services and applications which are currently using files that setup needs in order to complete the un-installation of SQL Server 2008 Service Pack 1. Click Next to continue with the un-installation process.



6. In Ready to remove the update screen you can verify the features which you have selected so far to be updated. Click Remove to continue with the un-installation process.



7. In Removal Progress screen you will be able to see Success messages as soon as the un-installation of SQL Server 2008 Service Pack 1 (SP1) has successfully completed. Click Next to complete the un-installation process.



8. In Complete screen you will be able to see the message Your SQL Server 2008 remove update operation has completed successfully. You can also verify the un-installation process activities by going through the summary log. Click Close to end the un-installation process.



9. You can verify the SQL Server 2008 product version by executing the below mentioned query in SQL Server Management Studio (SSMS)

SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'
GO