chunkdata and snapshotdata tables -- sql server reporting services

CR
9/26/2004 9:51:02 PM

Can someone advise under what conditions these tables are populated? I
gather from the documentation that if you set the 'Render this report from
an execution snapshot ' Properties of a report through ReportManager via a
schedule or whatever then the snapshot will be created as per the schedule
and stored.

I don't believe there are any snapshot schedules on the RS server, and the
'History' and 'Schedule' table is empty but the 'SnapshotData' and
'ChunkData' tables are accumulating daily.

I think they should be empty; nothing in BOL about, any insight on these

Daniel Reib [MSFT]
9/27/2004 7:39:36 AM

Snapshots are generated for every report rendering. Depending on the
context the report was rendered in the snapshot may only be available to
certain users under certain conditions. The RS Temp db and the catalog DB
both store snapshots depending on how "permanent" the snapshot is.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : chunkdata and snapshotdata tables