Srinivasulu Nasam


Technical Article

Create Log tables and Triggers

Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]

1.17 (6)

2007-10-26 (first published: )

4,216 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Azure Pricing, SQL Server seems pretty high?

By keven11

Hi, I'm really new to this and I think I've got this wrong, wondering...

Linked Server only tables in catalog are available

By daniel.dolan

I have two servers, ServA and ServB. ServA is set up as a linked...

NOT and NULL

By kuopaz

I've been here before on this but have come across it again, so wanted...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers