In this video of SSRS Tutorial, we will learn about ReportServer and ReportServerTempDB.
We will learn below items in this video
ReportServer Database Objects:
Select * from dbo.Catalog
Select * From dbo.DataSource
Select * From dbo.DataSet
Select * From dbo.Subscription
This table contains information for schedules on which the subscriptions are scheduled.
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:
dbo.Catalog:
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
Dbo.DataSource:
This table stored all the Data Sources embedded or shared.Select * From dbo.DataSource
Dbo.DataSets:
It stores list of shared data sets.Select * From dbo.DataSet
Dbo.Subscription:
This table stored the information related to Subscription such as Description,LastStatus,EventType,Parameters and deliveryExtensionSelect * From dbo.Subscription
Dbo.Schedule:
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