Rockwell Automation RSBizWare Administration Guide - Manual (Page 273)

Data compression Appendix C
The Select Users or Roles dialog box appears.
7. Under Enter the object names to select, type
public
, and
then click Check Names.
8. Click OK.
The name appears under Users or roles.
9. Under Permissions for public, select the Grant check box for
the Execute permission.
10. Click OK.
11. Repeat the steps for the other stored procedures.
To query the data from the Uncompress view, use the following
stored procedures in the SQL Server Query Analyzer:
Use this stored procedure: To specify:
spSetUncompressTimeRange <start
date/time, end date/time> The time range for which data will be
returned.
spSetUncompressReportingTag <reporting
tag name> A single reporting tag for which data will be
returned.
NOTE
You may further refine your query of the data from the Uncompress view
by following the SetUncompress statements with a SELECT statement
containing a WHERE clause.
The time range and/or reporting tag name that you specify in these
stored procedures are kept in the UncompressReportingTags and
UncompressTimeRange worktables. To clear the values from the
Querying the SQL Server
uncompress view
Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 273