Hey everyone!! We have a SQL Server 7.0 database that just came up with a problem. It seems as if all of the data in two of the tables just disappeared. Of course, no one in the company knows anything about it. Is there any way to grab a log file and see when/who deleted all of the data? It was most likely done through Enterprise Manager. I know of the DBCC LOG function, but don't think that gives the information I'm looking for. Any help is greatly appreciated. Thanks...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
