Determine if Service Pack 1 is installed on SQL 2005 ?

How can I determine if SP1 is installed for SQL Server 2005?

TIA

select @.@.version

Frank

|||

Since this is the SSIS forum, I thought a SSIS specific method my be usefull. Since you don't have to install the DB engine, you may just have SSIS installed, so the normal @.@.VERSION does not work anymore. One method is to check the File Version of the SSIS Service, C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.exe

Right-click the file and select Properties. On the Version tab check the File Version property. RTM shows 9.00.1399.00, SP1 shows 9.00.2047.00

Strictly speaking the MsDtsSrvr.exe may not always be updated with a service pack or patch, so the version may reflect an older level. An alternative method is to check the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup, values Version and PatchLevel give the service pack and hotfix level respectively. The RTM values are both 9.00.1399.06, and SP1 is 9.1.2047.00. Note the 9.1 rather than 9.0 for the SP1 version.

|||Actually "select @.@.version" works well in 2005.