sql server reporting services: What does the ReportServer and ReportServerTempDB dbs contain ? -- sql server reporting services

What does the ReportServer and ReportServerTempDB dbs contain ?

anandsagar NO[at]SPAM gmail.com
9/15/2004 11:43:59 PM

sql server reporting services:

I am developing reports on my desk computer, deploying on another
computer (the reporting service server) which has the actual SQLServer
database for the . What actually happens when I deploy the product ?
Is there anything that gets written in the Reporting Service database
? Any entries go into the 'ReportServer' or 'ReportServerTempDB'
database ? I looked into the user tables in the 2 databases, couldnt
find any comprehensive information.

Can anything useful be done by doing inserts, updates on tables in
'ReportServer' or 'ReportServerTempDB' ?

Any thoughts ?

Thanks,

Re: What does the ReportServer and ReportServerTempDB dbs contain ?

Bruce Loehle-Conger
9/16/2004 8:08:22 AM

I think you are playing with fire to go anywhere near these databases. For
one thing, even if you figured out what they are doing it is undocumented
and unsupported and could change in the future. Most everything you would
need to do can be handled either by URL integration or web services.

RS is using SQL Server to store all the report information. Search your
server, you will notice that there are no RDL files. Part of the deployment
process are these files getting stored in SQL Server. RS uses it for many
other things as well.

Bruce L-C

[quoted text, click to view]