SQL Server 2005 Service Pack 2 Issue

[kgreer]

I am having a issue with installing Service Pack 2 on a SQL 2005. I ran the update and even rebooted the machine, but when I run the command SELECT @@VERSION this is what is returned:


Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I ran the service Pack 2 update on my test server and was able to get it to return this:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


Is there another step I am missing?

Please any help would be great.

 

[mrdenny]

Build 3042 is SQL SP2. The Service Pack 1 listed below is the OS Service Pack.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kgreer]

Thanks for the reply. I reliazed that after I submitted the post. Its on SP2