Rockwell Automation RSBizWare Administration Guide - Manual (Page 272)

Appendix C Data compression
range and options selected, the chart will display either individual
values for the collected data point obtained by uncompressing the
block, or the summary information from the compressed block.
Additionally, the Information Services Manager utilizes a powerful
sampling algorithm, which may be invoked if a large time span is
selected for the chart.
Compressed data can also be viewed through the Uncompress view,
available only in the SQL Server RSBizWare database.
Before using the SQL Server Uncompress view, you need to grant
the EXECUTE permissions to the public user for the following
stored procedures:
• sp_OACreate
• sp_OADestroy
• sp_OAGetErrorInfo
• sp_OAMethod
• sp_OAStop
To grant the EXECUTE permission for a stored procedure:
1. Open the SQL Server Management Studio.
2. In the Object Explorer, expand Databases > System
Databases > master > Programmability > Extended Stored
Procedures > System Extended Stored Procedures.
3. Under System Extended Stored Procedures, locate the
stored procedure, for example sp_OACreate.
4. Right-click the procedure, and then click Properties.
The Extended Stored Procedure dialog box appears.
5. Under Select a page, click Permissions.
6. In the right pane of the window, click Search.
Preparing the SQL Server
uncompress view
272 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014