Sentry-go Alert Table for Microsft SQL Server

The SQLServer.sql.txt file provides DDL that will create an Alerts table in the appropriate SQL Server database.

Assuming the above DDL file is run unmodified, to log triggered alerts, simply update the monitor's configuration and, from the "Logging" tab, enter the following SQL INSERT statement. 

INSERT INTO SentrygoAlerts 
(TimeOccurred, Server, CheckName, AlertText) 
VALUES ('<$$TIMELOGGED>', '<$$SERVER>', '<$$TEST>', Left('<$$ERROR>', 499))