Srinivasulu Nasam


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: )

3,671 reads

Blogs

Daily Coping 5 Aug 2021

By

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

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

cheap hennessy

By bion

Are you looking for quality Wine, Champagn,Hennessy or Heineken for your birth day party,wedding,events...

is Forced Parameterization usually more beneficial than less?

By VoldemarG

On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with...

Celebrating Lives

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Lives

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers