Generic trigger for maintaining the Audit Log

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

SQL Server System Audit Report

SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.

SQL Login Password Audit

Audit your SQL logins to find passwords that have never been changed or that are very weak.

SQL Login Password Audit

Audit you SQL Logins

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts

RE: SQL 2000 Runtime

Not sure what you mean by "runtime version" or "product version", but Reporting Services can be obtained from Microsoft and is 'free' to use with an existing SQL Server license. See this FAQ for more info: http://www.microsoft.com/sql/reporting/howtobuy/faq.asp

RE: Writing to a text file using t-sql

In this case, the sp_OAxxx procs are overkill.imo, they are to be avoided if possible. There are way too many issues with sp_OAxxx procs for me to consider them as a reliable option.just my .02 though /Kenneth

RE: Stored Proc vs Query

I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes. I tested this change in one server and I am testing it in other servers now. I will let you know. Thanks.