Stored Procedures

Some stored procedures are useful when performing database queries to return information about specific tags in the system. These stored procedures allow you to return information on a tag's definition or to narrow the scope of a query on a data storage table. You can use these stored procedures when querying the database using ad-hoc query tools, such as SQL Server Management Studio.

Other stored procedures are used to configure AVEVA Historian. System stored procedures are normally run during startup and during changes to the system configuration. These stored procedures are used mainly by the historian setup program, the Event subsystem, the Operations Control Management Console, and client applications.

Note: Stored procedures prefixed with "ww_" are provided only for backward compatibility and are deprecated. For more information, see Renamed Stored Procedures.