Denise McMillan
SSCertifiable
Points: 6216
More actions
July 2, 2007 at 10:39 am
#175131
Is there a way to get any changes made to data for say the past year by user?
Thanks for any ideas.
K. Brian Kelley
SSC Guru
Points: 114642
July 2, 2007 at 11:24 am
#716605
Unless you had auditing via triggers or traces or a 3rd party product, unfortunately not. SQL Server does not store this type of information natively.
K. Brian Kelley@kbriankelley
July 2, 2007 at 2:10 pm
#716653
That's what I thought but I wanted to be sure. Thanks very much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply