Re: About C2 audit mode and SQL Profiler
From: Richard Waymire [MSFT] (rwaymi@online.microsoft.com)
Date: 03/29/03
- Next message: Darko Grujic: "Re: Role activation"
- Previous message: Mary Chipman: "Re: ms access sql server security"
- In reply to: ton: "About C2 audit mode and SQL Profiler"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Richard Waymire [MSFT]" <rwaymi@online.microsoft.com> Date: Sat, 29 Mar 2003 10:14:51 -0800
#1) C2 mode has very specific requirements - including writing to a file.
You'll need to run an ordinary trace (with sp_trace* or profiler) for any
non-default behavior otherwise.
#2) See #1
#3) Use the profiler GUI to create the trace you'd like to run. Then script
the trace (file - script trace menu). Then wrap the whole script in a
stored procedure, then mark the stored procedure as a "startup" stored proc.
Then it will start each time SQL Server starts.
-- Richard Waymire, MCSE, MCDBA This posting is provided "AS IS" with no warranties, and confers no rights. "ton" <barameek@inglife.co.th> wrote in message news:e0GPUsA9CHA.1980@TK2MSFTNGP12.phx.gbl... > I have 3 problems as follow : > > 1. How can i change c2 audit from text file to table on database? > > I set c2 audit mode to sql server 2000 and this mode will generate > text file to \program files\Microsoft SQL > Server\Mssql\data\audittrace_xxxxxxxxxxxxxx.trc but > i want to change output of audit to table on database like sql profiler > trace. > > 2. How can i increase default c2 audit mode? > > 3. How can i set trace of SQL Profiler for run automatic when sql server > 2000 startup? > > > Thank in advances. > >
- Next message: Darko Grujic: "Re: Role activation"
- Previous message: Mary Chipman: "Re: ms access sql server security"
- In reply to: ton: "About C2 audit mode and SQL Profiler"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
