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,568 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

leave entitlement and balance

By tanehome

Hi all I need your advise for the below case: I’ve a leave request...

How to encode the following dynamical SQL scripts

By 892717952

I use one table (call first table) field's value to update another another table...

SQL Server Phone Home

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Phone Home

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers