I'm using a COTS product that bundles the Microsoft Database Engine (MSDE).
We had to enable C2 auditing within MSDE but don't know how to view the logs
that are produced. If using a full version of SQL Server, you can view the
logs using SQL Profiler but with MSDE, I don't see what I can use. Can
someone tell me how I can view these logs without installing a third party
product?
Thanks for the help,
MarkOne option is to use fn_trace_gettable.
You can execute a query to view the files with something
like:
select *
FROM ::fn_trace_gettable('D:PathToYour\TraceF
ile.trc,
default)
You could use a select * into to import the files into a
table if you prefer.
-Sue
On Wed, 19 Jan 2005 13:27:10 -0800, "Mark@.GDC4S"
<Mark@.GDC4S@.discussions.microsoft.com> wrote:
>I'm using a COTS product that bundles the Microsoft Database Engine (MSDE).
>We had to enable C2 auditing within MSDE but don't know how to view the log
s
>that are produced. If using a full version of SQL Server, you can view the
>logs using SQL Profiler but with MSDE, I don't see what I can use. Can
>someone tell me how I can view these logs without installing a third party
>product?
>Thanks for the help,
>Mark
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment