check_snmp_mssql plugin overview.

Plugin checks snmp status of databases on target mssql service,
check difference list of databases from last check and alert admins.
For check difference you need run plugin with option -H <host> -i
And then you can check differences with option -H <host> -c
When new database is created alert has status "WARNING"
When database is deleted alert has status "CRITICAL"
Otherwise alert has status "OK" if no errors given.

If you don't see MSSQLServer variables in SNMP Browser ex. 
http://www.wtcs.org/snmp4tpc/FILES/Tools/SNMP/getif/getif-2.3.1.zip or SNMP enabled after installation of MSSQL Server, use regfile.
Regfile correct path to MSSQLServer snmp library.
After use regfile restart SNMP service.

If you need edit registry keys.
----
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/SNMP/CurrentVersion
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/SNMP/Parameters/ExtensionAgents
----

Example of syntax:

----- checkcommands.cfg -----
# 'check_mssqlalldb_stat' command definition
define command{
        command_name    check_mssqlalldb_stat
        command_line    $USER1$/check_snmp_mssql -H $HOSTADDRESS$
        }

# 'check_mssqldb_stat' command definition
define command{
        command_name    check_mssqldb_stat
        command_line    $USER1$/check_snmp_mssql -H $HOSTADDRESS$ -d $ARG1$
        }
# 'init_mssqldb_list' command definition
define command{
        command_name    init_mssqldb_list
        command_line    $USER1$/check_snmp_mssql -H $HOSTADDRESS$ -i
        }
# 'compare_mssqldb_list' command definition
define command{
        command_name    compare_mssqldb_list
        command_line    $USER1$/check_snmp_mssql -H $HOSTADDRESS$ -c
        }
----- checkcommands.cfg -----

----- services.cfg -----
define service {
        use                             generic-service         ; Name of service template to use
        host_name                       Database
        service_description             Database DB Status
        check_command                   check_mssqlalldb_stat
        check_period                    24x7
        max_check_attempts              5
        normal_check_interval           2
        retry_check_interval            1
        contact_groups                  db-admins
        notification_interval           60
        notification_period             24x7
        notification_options            w,u,c,r
#       register 0
}
----- services.cfg -----