Understanding stored procedures
- Last UpdatedApr 24, 2025
- 1 minute read
This describes the stored procedures which are available for execution via the Microsoft SQL Engine and how to configure the Microsoft SQL Engine to access additional BLT components hosted by local AVEVA Enterprise SCADA services.
The following stored procedures are available with the basic AVEVA Enterprise SCADA services:
|
Service |
Qualifier |
Name |
|---|---|---|
|
Common |
SCHEMA |
set_skip |
|
Common |
SCHEMA |
set_display |
|
Common |
SCHEMA |
set_trace |
|
Common |
SCHEMA |
sp_columnsXML |
|
Common |
SCHEMA |
sp_databasesXML |
|
Common |
SCHEMA |
sp_fkeysXML |
|
Common |
SCHEMA |
sp_pkeysXML |
|
Common |
SCHEMA |
sp_tablesXML |
|
Common |
SCHEMA |
use |
|
RealTime |
RTDB |
AddSYSalarm |
|
RealTime |
RTDB |
SpoolControl |
|
RealTime |
RTDB |
SpoolMsg |
|
RealTime |
RTDB |
Trend |
|
RealTime |
RTDB |
Trendview |