chekck ServicePack

[Bob]

Hello...
I've tried

Select @@version
and
exec xp_msver

I don't see the SP level.

@@version returns:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.0 (Build 6000: )

I ran SP2 and was told that what I had was more recent.

I'm trying to install SSRS but it's Grayed out and unselectable.
... the kb article says that SP2 is required.


any help would be much appreciated.
thanks!
bob.

 

[Sylvain Lafontaine]

For checking the service pack, use:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

or see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

For your problem about installing SSRS, I've no idea. You should post in a
more relevant newsgroup (m.p.sqlserver.*) and provide more details about
your Windows installation. Telling which KB article you are trying to
follow would also be a good idea.