Kevin, Does this help? https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/
You may need a little work to get what you want but it seems like all the info you want is in the log. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kevin J Cully Sent: 06 June 2017 21:46 To: 'ProFox Email List' <[email protected]> Subject: [NF] Find table where last record was added Hello all, I'm trying to (partially) reverse engineer how an ERP system is working. It uses M$ SQL Server and it has hundreds of tables. I know most of the tables that store actual data, but I know that there must be tables where the business rules are stored. Is there a way to query a system table for which table just had a record added to it? There are lots of pages showing how to get the last record added in a table, but this isn't what I'm needing. I'm wanting to add a (test) business rule, and then find what table(s) that got written into. I believe this query gives me the last time the table structure has changed, but that's not what I want either: SELECT [name],create_date,modify_date FROM sys.tables order by modify_date desc Thanks, Kevin This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
