(Solved) : Using Adventureworks Database Implement Test History Data Auditing Model Update Delete Ac Q30205815 . . . .

. Using the AdventureWorks databaseimplement and test the History data auditing model for UPDATE andDELETE actions on any table

create table Address with 3 columns with the same structure asthe original table + hist_date + username + hist_id +operation_type

Table properties

namevaluename[Person].[Address]createdMar 19 2009 9:08PMmodifiedMar 19 2009 9:08PMansi nullsonquoted identifieronrow count19,614Size of data2,240 kbSize of indexes2,504 kbMaximum size of a single row692 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcommentAddressIDint identity(1,1)104noyesnoPrimary key for Addressrecords.AddressLine1nvarchar(60)60240nonoFirst street address line.AddressLine2nvarchar(60)60240yesnoSecond street address line.Citynvarchar(30)30120nonoName of the city.StateProvinceIDint104noStateProvince.StateProvinceIDnoUnique identification number forthe state or province. Foreign key to StateProvince table.PostalCodenvarchar(15)1560nonoPostal code for the streetaddress.rowguiduniqueidentifier3616(newid())nonoROWGUIDCOL number uniquelyidentifying the record. Used to support a merge replicationsample.ModifiedDatedatetime238(getdate())nonoDate and time