Home Forums SQL Server 2005 Administering Auditing All Activity RE: Auditing All Activity
Ron McCullough
SSC Guru
Points: 63877
More actions
December 17, 2008 at 4:11 pm
#914228
You might also want to try:
fn_trace_gettable
as:
SELECT *
FROM fn_trace_gettable
('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)
The location above is the default location for traces, yours may have been altered.
If everything seems to be going well, you have obviously overlooked something.
RonPlease help us, help you -before posting a question please read[/url]Before posting a performance problem please read[/url]