Is there anyway of getting the creation date of an entry in an SQL Server table? The reason I want to know the creation time of an entry is for debugging purposes.
A:
AFAIK- No, unless you have a field for that and you are setting it when doing INSERT/UPDATE
shahkalpesh
2009-07-30 03:06:45
ok.. i hope you're wrong :). But i think you're right... i'll wait and see..
seanlinmt
2009-07-30 03:11:07
:). Why will a DBMS do a job without you telling it to?
shahkalpesh
2009-07-30 03:16:49
who knows.. I'm not an expert. Life is full of surprises. Too bad no surprises here. :)
seanlinmt
2009-07-31 10:42:12
A:
If you are logging your transactions, then you can analyze the transaction log to see all the INSERT, UPDATE and DELETE statements. I'm no expert by any means, but depending on your SQL Server version, you may be able to find a tutorial somewhere. Here's one for SQL 2000.
womp
2009-07-30 03:10:49
A:
You can add a datetime field with a default value of GETDATE() to retain the creation date of a record. There is no supported way of retrieving this info after the fact. In theory you can walk the log and find the log entry for the insert, but that requires use of undocumented functions like fn_dblog() or specialized third party tools like SQL Apex.
Remus Rusanu
2009-07-30 03:10:56