Get and Store composite primary keys

ianperrin / sqlclrdataaudit

Automatically exported from code.google.com/p/sqlclrdataaudit

0 stars 0 forks source link

Get and Store composite primary keys #4

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

The original code only allows for single primary keys to be saved into the 
Audit table.

This needs modifying to allow tables wiht composite primary keys to be 
audited.

e.g. http://www.nigelrivett.net/AuditTrailTrigger.html

Original issue reported on code.google.com by ianper...@gmail.com on 13 Mar 2007 at 9:29

GoogleCodeExporter commented 9 years ago

Original comment by ianper...@gmail.com on 13 Mar 2007 at 1:01

Added labels: Type-Enhancement
Removed labels: Type-Defect

GoogleCodeExporter commented 9 years ago

Implemented a basic sqldatareader read loop to prove concept of 
INFORMATION_SCHEMA 
sql used in the referenced Nigel Rivett's Audit Trail Trigger.

Original comment by ianper...@gmail.com on 13 Mar 2007 at 5:09

GoogleCodeExporter commented 9 years ago

Original comment by ianper...@gmail.com on 14 Mar 2007 at 8:54

Changed state: Started

GoogleCodeExporter commented 9 years ago

a similar solution can be found here: 
http://forums.microsoft.com/MSDN/ShowPost.aspx?
PostID=1010082&SiteID=1

Original comment by ianper...@gmail.com on 14 Apr 2007 at 8:59