GitHub

SQL Server project that implements automatic database backup using a database trigger, stored procedure, and SQL Agent job scheduling.

There was an error while loading. Please reload this page. -- Auto Backup for SQL Server - Fixed Version -- Replace MyDB with your database name and ensure C:\DB ...
GitHub

-- Capture all unencrypted database connections using a Logon trigger

-- This script creates a Logon trigger that records into table tempdb.dbo.unencrypted_connections any unencrypted T-SQL TCP database connections except for those from SSMS. -- Some applications make ...
CIOL

Using DDL triggers in SQL server

BANGALORE, INDIA: It has been more than two decades since Relational Database Management Systems (RDBMS) have made transition from the laboratory to becoming the data store of choice for all large and ...