Deepak Ratan

Deepak Ratan

  • NA
  • 175
  • 48.6k

How to Create a Audit table

Jun 21 2015 11:01 PM
How to Create a Audit table for Insert, Update,Delete...?
For this Audit table how to write Trigger..? 
 
This is my Table 
 
Create table  Cust
 CustID  int PK
,PersonID   int FK
,StoreID  int FK
,TerritoryID   int FK
,AccountNumber   Computed varchar(10)
,rowguid   Uniqueidentifier
,ModifiedDate  datetime
 

Answers (2)