Micro Focus Studio Enterprise Edition Test Server > Programming > Data Access > Micro Focus Database Connectors Version 2.0 for Windows > Database Connectors User's Guide > Database Connectors for Microsoft SQL Server > Stored Procedures > Built-in Stored Procedures

Built-in Stored Procedures

Several stored procedures come with Database Connectors for MSSQL. One, sp_AcuInit, provides a means for customized initialization. sp_AcuInit is not installed; you must create it to use it for connection-time set-up. The others return information based on the AcuOpenTables1 and AcuLocks1 tables.

Note: Names of several stored procedures end in _1, indicating the first version of the stored procedure. Whenever a stored procedure is updated, the extension is updated by one. This is why you can install new stored procedures without overwriting older ones. Be sure to install all stored procedures when you install Database Connectors for MSSQL.

sp_AcuInit	A procedure you can set up to do customized initialization
sp_AcuRemoveUnusedLocks_1	Determines who is logged in and removes Process IDs that are no longer active on the system
sp_AcuTableReport_1	Shows who is using the tables in the database at the time this procedure is run
sp_AcuUserCount_1	Use this to track table and database activity to ensure that your database is running as efficiently as possible
sp_AcuZeroUserCount_1	Removes all locks on a table and closes it