<p>The table doesn't have a last updated field and I need to know when existing data was updated. So adding a last updated field won't help (as far as I know).</p>

[{'answer_id': 2810, 'author': 'huseyint', 'author_id': 39, 'author_profile': 'https://Stackoverflow.com/users/39', 'pm_score': 0, 'selected': False, 'text': '<p>You can add a timestamp field to that table and update that timestamp value with an update trigger.</p>\n'}, {'answer_id': 2842, 'author': 'Mufaka', 'author_id': 449, 'author_profile': 'https://Stackoverflow.com/users/449', 'pm_score': 4, 'selected': True, 'text': '<p>SQL Server 2000 does not keep track of this information for you. </p>\n\n<p>There may be creative / fuzzy ways to guess what this date was depending on your database model. But, if you are talking about 1 table with no relation to other data, then you are out of luck.</p>\n'}, {'answer_id': 2854, 'author': 'GateKiller', 'author_id': 383, 'author_profile': 'https://Stackoverflow.com/users/383', 'pm_score': 0, 'selected': False, 'text': '<p><a href="http://www.krell-software.com/omniaudit/index.asp" rel="nofollow noreferrer">OmniAudit</a> is a commercial package which implments auditng across an entire database.</p>\n\n<p>A free method would be to write a trigger for each table which addes entries to an audit table when fired.</p>\n'}, {'answer_id': 2890, 'author': 'Chris Miller', 'author_id': 206, 'author_profile': 'https://Stackoverflow.com/users/206', 'pm_score': 1, 'selected': False, 'text': "<p>You can't check for changes without some sort of audit mechanism.  You are looking to extract information that ha not been collected.  If you just need to know when a record was added or edited, adding a datetime field that gets updated via a trigger when the record is updated would be the simplest choice.</p>\n\n<p>If you also need to track when a record has been deleted, then you'll want to use an audit table and populate it from triggers with a row when a record has been added, edited, or deleted.</p>\n"}, {'answer_id': 38900, 'author': 'Matt', 'author_id': 4154, 'author_profile': 'https://Stackoverflow.com/users/4154', 'pm_score': 1, 'selected': False, 'text': '<p>You might try a log viewer; this basically just lets you look at the transactions in the transaction log, so you should be able to find the statement that updated the row in question.  I wouldn\'t recommend this as a production-level auditing strategy, but I\'ve found it to be useful in a pinch.</p>\n\n<p>Here\'s one I\'ve used; it\'s free and (only) works w/ SQL Server 2000.</p>\n\n<p><a href="http://www.red-gate.com/products/SQL_Log_Rescue/index.htm" rel="nofollow noreferrer">http://www.red-gate.com/products/SQL_Log_Rescue/index.htm</a></p>\n'}]
['https://Stackoverflow.com/questions/2809', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/437/']