Alarm database stored procedures

You can use a set of SQL Server stored procedures to easily retrieve information for analysis and reporting of alarms and events.

A stored procedure is a collection of SQL statements that perform a specific function and return data from the database. Stored procedures can accept input parameters that govern how they are to operate, and they return data in the form of a result set.

The returned results are a set of records and appear as a SQL record set very similar to a SQL Server database view. Stored procedures can improve performance because they exist in the database with their embedded SQL statements and reduce round-trips back to the client.

For more information about stored procedures, including how to view the definitions for them, see your Microsoft SQL Server documentation.