February 8, 2012 at 11:50 am
Hello fellow SQL'ers,
I have been assigned a task to create a new ERD for the database that I have never worked with before. I bought Red-Gate's SQL Dependency Tracker and it works great, but I need a little more assistance. What I really need is a DMV or script that allows me to search a database for any new records entered into the database. I understand that every database is different and the likelihood that there is a single script that accomplishes this is limited, but hopefully someone has something they have used in the past and I can manipulate it. Thank you.
February 8, 2012 at 12:24 pm
There is no DMV or view that tracks new records automatically.
If you need to identify new records, you need something like an insert date column or triggers on the tables or something like Change Tracking or change data capture.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply