SSRS Tutorial Part 128 - Reporting Services Databases ( ReportServer and ReportServerTempDB)

In this video of SSRS Tutorial, we will learn about ReportServer and ReportServerTempDB.

We will learn below items in this video

ReportServer Database:

ReportServer is the database which is used to store Metadata and Definition of Objects used by Reporting Server.

ReportServer TempDB:

ReportServerTemp DB is created with ReportServer Database.It stores temporary data, session information, and cached reports.

ReportServer Database Objects:


This table contains information related to Home,Folders,Sub Folders, Reports,Data Sets,Data Sources, Report Definition(XML) as content column

Select * from dbo.Catalog


This table stored all the Data Sources embedded or shared.

  Select * From dbo.DataSource


It stores list of shared data sets.

Select * From dbo.DataSet


This table stored the information related to Subscription such as Description,LastStatus,EventType,Parameters and deliveryExtension

Select * From dbo.Subscription


This table contains information for schedules on which the subscriptions are scheduled.

Introduction to SSRS Databases ( ReportServer and ReportServerTempDB) - SQL Server Reporting Services (SSRS) Tutorial

No comments:

Post a Comment