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 ...
LinkedIn

Jayeshkumar Prajapati’s Post

Day 18: Trigger in SQL Server - It is a database object which executes when an event occurs in a database. Types of Trigger - DDL Trigger - It is executed in response to DDL command events like Create ...
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 ...
LinkedIn

How can you create a trigger in a database?

A trigger is a named block of code that is associated with a table, view, or schema in a database. It runs before or after a specific event, such as an insert, update, or delete operation, on the ...