Db Maint Utility stored procedures

Utility stored procedures

There are so many things that you might want to do in a task or job, so instead of incorporating each feature in Db Maint, we have added hooks to execute TSQL batches from within a task or a job. If the batch returns any output or error messages, they will be logged to the Db Maint log. Instructions for how to use the procedures are found in each script file. Maint Corp. do not take any responsability for any damages or data losses that these procedures might cause.

Alert if filegrowth occured
sp_dbm_checkfilegrowth.sql

List NT group membership
sp_dbm_get_NTgroup_membership.sql

Check identity values
Check identity value for all tables in a database which are using an identity column. This procedure can be scheduled or specified as a SQL Server startup procedure.
sp_dbm_checkident.sql

Generate a warning if a database is fuller than a specified value
sp_dbm_warn_if_full_db.sql

Execute an NT batch file from a SQL Server connection
sp_dbm_exec_batch.sql

Send message to SQL Server users
With this procedure you can issue a NET SEND to all users connected to SQL Server.
sp_dbm_notify_users.sql
sp_dbm_notify_users.bat

Save resultset as file
sp_dbm_query_to_file.sql

Terminate all connections for a database
This procedure issues the KILL statement for all connections connected to a specified database.
sp_dbm_kill_users.sql

Check if a string is an ANSI or SQL Server reserved keyword
sp_dbm_nameok.sql
dbmsys_reserved_words.sql