How To Read A Log File 1

[JamesJKusch]

Need to find a way to discover when tables where dropped and recreated. This procedure of course creamed our data. Would like to know where these transactions are captured and a way to view some type of date_time stamp. Would it be found in the T-logs or someplace else?

Thanks Again Thanks for all the help ... As Usual

J. Kusch
Chameleon Solutions, Inc.

 

[foxbox]

SELECT crdate
FROM sysobjects
WHERE name = <tablename>

tells you when the object was created.

I think you have to create a storedprocedure for the DROP action, which logs the date/time

br
Gerard