[dba-SQLServer]Tracking events

Porter, Mark MPorter at acsalaska.com
Wed Apr 2 12:05:02 CST 2003


DB=SQL Server 7

We've had a bit of a disaster here, and would like to know its cause.  Our
production system (SIEBEL) went down late last night and, after
investigating the tables, we found that a few of the critical tables had
been recreated (via the Create Date) late in the evening.  They were empty.

I'm a developer, not an Admin, so I don't know how to track who did what and
when.  Is there any way to access the SQL Server log files to determine how
the drop and recreate happened?

Thanks,

Mark


This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.


More information about the dba-SQLServer mailing list