How to Determine Which Features Are Installed for SQL Server 2005

  • The former DBA responsible for SQL Server 2005 left the organization unexpectedly, and, sadly, he was allergic to writing documentation. We work in a very secure environment, without local console access to the SQL Server machines, but we have SQL Server sa accounts.

    Is there a query that we can run to determine if Reporting Services, etc. is installed on a given instance?

  • Only thing I could recollect is to run the following command.

    Select [NAME] ,DATABASE_ID from Master.sys.databases where [Name] like '%$%TempDB'

    If the command returns any rows, then it would be an indication that Reporting Server is installed. the reason I say it is an indication is, it may also be a user created database.

    But I tried looking in all of my Reporting Server TempDB's the Database_ID in the above mentioned table is 6. Hope it may be useful.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Thanks. This helps. I see a couple databases named ReportServerTempDB and one named MossReportTempDB. I'm not sure what MossReportTempDB is. Is that a "standard" database name for Microsoft Office SharePoint?

  • May be, I have not worked on Sharepoint, but MOSS usually indicates that.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • You could also list the services through SQL as well, this will tell you if the reporting services portion was installed, won't tell you if it is configured\used

    create table #test (test nvarchar(max))

    insert into #test

    exec master..xp_cmdshell 'net start'

    select * from #test

    drop table #test

    Andrew

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply