Versions

[qsac]

How can i tell what versions eash of my isntalls are on?

For instance, say I installed Reporting services after SQL Database Services, and cant remember if I did SP2 or not. is there a way to tell what version SSRS is on?

Thanks
Q

 

[mrdenny]

Right click on the exe and select properties.
Go to the

http://servername/ReportServer/

URL. The version should be listed there.

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

 

[qsac]

is there any sort of a comman line?

like if i wanted to get the version for SSRS, SSNS, and SSAS all at once?

 

[mrdenny]

As far as I know there isn't a way to query SSRS and SSNS. SSAS you should be able to query (I don't have SSAS installed here yet, so I can't check).

Don't get used to using Notification Services. It's been removed from SQL Server 2008.

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