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

name value
name [Person].[Address]
created Mar 19 2009 9:08PM
modified Mar 19 2009 9:08PM
ansi nulls on
quoted identifier on
row count 19,614
Size of data 2,240 kb
Size of indexes 2,504 kb
Maximum size of a single row 692 bytes

Columns

column datatype length bytes default nulls PK FK UQ computed comment
AddressID int identity(1,1) 10 4 no yes no Primary key for Addressrecords.
AddressLine1 nvarchar(60) 60 240 no no First street address line.
AddressLine2 nvarchar(60) 60 240 yes no Second street address line.
City nvarchar(30) 30 120 no no Name of the city.
StateProvinceID int 10 4 no StateProvince.StateProvinceID no Unique identification number forthe state or province. Foreign key to StateProvince table.
PostalCode nvarchar(15) 15 60 no no Postal code for the streetaddress.
rowguid uniqueidentifier 36 16 (newid()) no no ROWGUIDCOL number uniquelyidentifying the record. Used to support a merge replicationsample.
ModifiedDate datetime 23 8 (getdate()) no no Date and time the record was lastupdated.

Indexes

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *