September 9, 2008 at 9:05 am
Hi,
Today i see that one of the tables was deleted in one of our databases. And i want to know the reason. Can i learn it in SQL Server 2005 ? (I didn't make auditing for that database )
Thanks.
September 9, 2008 at 9:37 am
You may be able to get the information you want by querying the defalut trace that is enabled by default in SQL Server 2005. It only keeps up to 100 MB of data, so you'll want to do this soon. You can read the trace file with Profiler. See "default trace enabled option" in BOL.
Greg
September 9, 2008 at 9:53 am
Thanks but i couldn't find it in profiler? Can you explain where can i fin it exactly?
September 9, 2008 at 10:00 am
The BOL page I mentioned previously says, "The default trace log is stored by default in the \MSSQL\LOG directory..." and "The base file name for the default trace log file is log.trc.".
Look for the directory on the server where the SQL Server instance resides.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply