Detect installed version?

Today I installed SQL Server 2005 developer edition on a test server. Afterwards I also installed the SP1. During the installation of SP1, the installation program said the server should be restarted afterwards, which I did.

Now when I look at the Add/Remove Programs dialog I have several items which mention SP1 on the SQL Server items.

But when I request the server properties in Managemnt Studio I see the version number 9.0.2047. Shouldn't this be 9.1.XXXX?

How can I be sure the SP1 is correcty insatlled?

Stievie

If you look on the download page under the Quick Details, the version number is listed as 9.00.2047

http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

|||Isn't that the same version number as before installing the SP?

Is it possible to see which SP is installed inside the Management Studio?

|||Hi,

See more details here: http://www.aspfaq.com/sql2005/show.asp?id=20

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

StievieD wrote:

Isn't that the same version number as before installing the SP?

Before SP1, the version is 9.0.1399

|||The version for SP1 is 9.00.2047 and RTM 9.00.1399.06.|||Thanks guys, for all the help.