Report Model - where is it stored?

Hello,

I'm trying to figure out where a "report model" is stored in the ReportServer database. Can anyone tell me the tables and views where a report model definition is stored internally?

Thanks,

BCB

The ReportServer's Catalog table contains the information you want (I think). To get the info stored for each report, you can use

use ReportServer;

select * from Catalog

where Type = 2;

HTH.

|||

Thanks for your reply. The query you provided will return the RS reports that are stored in the Catalog table. I modified your query to return the Model data that I wanted. (See below.) The Type column has a value of 6 for models as you can see in the query. The answer to my original question appears to be that report models are stored in their entirety in the Content column. It is an image column that has a capacity of 2 billion bytes. I put the model in the "black box" category because it does not seem to be implemented (in the physical sense) as views or procedures that can be examined with the naked eye - my favorite tool.

USE ReportServer;

SELECT

ItemID,

Path,

Name,

Description,

Content,

DATALENGTH(Content) AS [Content Length],

Type

FROM

Catalog

WHERE

Type = 6;