which database is SSRS database?

• alanspeckman

  Hall of Fame

  Points: 3344

  More actions

  January 6, 2014 at 11:02 am

  #281756

  I am writing a generic T-SQL script that needs to have sql server tell it what database(s) are configured as Reporting Services databases.

  This database is going to be mirrored, so I need the database name/id so I can use that with sys.database_mirroring to tell me if it is running as the principal or mirror role.

  Is there a DMV, system view, etc. that holds that information?

  Thanks,

  Alan.

• Steven.Howes

  SSCertifiable

  Points: 6230

  More actions

  January 8, 2014 at 1:34 pm

  #1678579

  Could you use the DATABASE_NAME() function and the Database_id column from the sys.database_mirroring table to get the name?

• Steven.Howes

  SSCertifiable

  Points: 6230

  More actions

  January 8, 2014 at 1:35 pm

  #1678581

  Sorry DB_NAME(). My brain said one thing my fingers typed another.