How could I know the version of Reporting Services in my machine?

How could I know the version of Reporting Services in my machine?

thanks

SELECT @.@.version

Or take a look at this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=445611&SiteID=1

How can you determine which version of SQL Server is installed on a machine? -

How can you determine which version of SQL Server is installed on a machine?select @.@.version|||Try the below mentioned query to even find Product Version, Product Level as well as the edition of SQL Server ...

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

--Sandu_Bangalore

How can I tune-up my SQL installation

Hi,

I have SQL desktop version installed and for the last few days it has really slowed down. I have ran many anti-virus etc. and all is okay on that front.

Any tips regarding how I can tune things up? What should I look for and how do I go about it. Deleting LOG etc. etc?

Please guide.

Thanks.There are many good tips here:

www.sql-server-performance.com|||Thanks for the URL. Will try it out.|||And also keep reference of the books online in most cases.
But as referred that website is an ocean of goodies for SQL performance.

How can I tell which version is installed?

One of the server admins recently installed SQL Server 2005 on a new Itamium server. I am trying to set the parameter on the services to indicate they are running on a 64 bit machine, however the changes are not taking...yes I'm stopping and restarting the services. I'm wondering if did not install the right version. Does anyone know how I can tell if the IA 64 version was installed?

I don't think you could install version other than ia64 on a Itanium machine.

If you could start the server, try following sql, it should return a version string which indicate whether is x86/amd64/ia64.

select @.@.version

|||

Duh! It never occurred to me that it might list the processor. Thanks!

Oh...I wish I had a brain!