Skip to content

Mohammad Darab

Data & AI Consultant at Microsoft

  • Home
  • About
  • Contact
  • Interviews
  • Speaking
  • Big Data Clusters

Category: Audit

Posted on December 28, 2015April 27, 2018

Create Database Audit for INSERT, UPDATE, DELETE in SQL Server

There are a few ways to monitor when someone makes an INSERT, UPDATE or DELETE in SQL Server. One quick and easy way is through SQL Server Audit. Below is a step-by-step way to create that audit:

Expand Security, then right-click Audits and click ‘New Audit…’ Continue reading “Create Database Audit for INSERT, UPDATE, DELETE in SQL Server”

About Me

Mohammad Darab

Mohammad Darab

Data & AI at Microsoft | Former MS MVP | CKA & CKAD | Blogger & Speaker
Read more...

Search

Microsoft Data Platform MVP

Certified K8s Administrator

Certified Kubernetes Administrator

Certified K8s App Developer

Mohammad Darab Certified Kubernetes Application Developer

IDERA ACE Class of 2019

IDERA ACE Class 2019

Newsletter

SQL Blog Awards

SQL server blogs

Mohammad Darab Blogger

Azure Data Fundamentals - Mohammad Darab
Azure AI Fundamentals
Azure Fundamentals Mohammad Darab

Popular Posts

  • How to Find Last Login Date of a SQL Server Login?
  • How to Stop & Delete a SQL Server Trace
  • Create Database Audit for INSERT, UPDATE, DELETE in SQL Server
  • What is the CLIUSR Local Account?
  • Perfmon Create New Data Collector Set Grayed Out (FIX)

Categories

  • Audit
  • Availability Groups
  • Azure
  • Backup Restore
  • Big Data Clusters
  • Blog
  • Blog Stats
  • Certification
  • DBA Toolkit
  • DBCC
  • DMVs
  • Docker
  • Failover Cluster
  • Guest Blog
  • HA / DR
  • Hyper-V
  • Interview
  • Kubernetes
  • Lab
  • Linux
  • Perfmon
  • Performance Tuning
  • Professional Development
  • Review
  • Script
  • Security
  • SQLCMD
  • SQL Saturday
  • SQL Server
  • SQL Server 2019
  • SSMS
  • STIGs
  • Training
  • Troubleshoot
  • TSQL
  • User Group

DISCLAIMER

This is my personal blog. The opinions I express here do not represent those of my employer. The information I provide is on an as-is basis. I make no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this blog and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its use.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Twitter
  • LinkedIn
  • YouTube
Proudly powered by WordPress