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

Blogs

Daily Coping 13 Apr 2021

By

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

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Read the latest Blogs

Forums

Error installing SQL Server 2014 (both 32 & 64 bit versions)

By Michele65

During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...

Linked server to Access accdb database

By richardmgreen1

Hi all   We've got a linked server from SQL 2016  to an accdb...

performance tuning

By rohitkocharda

Hi everyone, Any good suggestion to tune below query:   --CREATE NONCLUSTERED INDEX nonclust_code...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers