Microsoft SQL Engine stored procedures
- Last UpdatedApr 24, 2025
- 1 minute read
The Microsoft SQL Engine supports several built-in stored procedures which are available for execution, and provides access to a sub-set of BLT components hosted by local AVEVA Enterprise SCADA services.
The following stored procedures are available when the associated AVEVA Enterprise SCADA service is running:
|
Service |
Qualifier |
Name |
|---|---|---|
|
Common |
SCHEMA |
set_skip |
|
Common |
SCHEMA |
set_display |
|
Common |
SCHEMA |
set_trace |
|
Common |
SCHEMA |
sp_columnsXML |
|
Common |
SCHEMA |
sp_databaseXML |
|
Common |
SCHEMA |
sp_fkeysXML |
|
Common |
SCHEMA |
sp_pkeysXML |
|
Common |
SCHEMA |
sp_tablesXML |
|
Common |
SCHEMA |
use |
|
RealTime |
SCHEMA |
AddSYSalarm |
|
RealTime |
SCHEMA |
SpoolControl |
|
RealTime |
SCHEMA |
SpoolMsg |
|
RealTime |
SCHEMA |
Trend |
|
RealTime |
SCHEMA |
TrendView |
Related Links
- Execute the set_skip stored procedure
- Execute the set_display stored procedure
- Execute the set_trace stored procedure
- Execute the set_columnsXML stored procedure
- Execute the set_databaseXML stored procedure
- Execute the set_fkeysXML stored procedure
- Execute the set_pkeysXML stored procedure
- Execute the set_tablesXML stored procedure
- Execute the use stored procedure
- Execute the AddSYSalarm stored procedure
- Execute the SpoolControl stored procedure
- Execute the SpoolMsg stored procedure
- Execute the Trend stored procedures
- Execute a Trendview stored procedure