LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » SQL Server Security » Sql Server 2008 Audit

Sql Server 2008 Audit

Options

Previous Topic · Next Topic

pavanveeradba

Posted: Wednesday, September 30, 2009 2:10:06 AM

Rank: Newbie

Joined: 9/30/2009
Posts: 1
Points: 3
Where do you live?: singapore

Dear all,

how to configure Audit in SQL Server 2008?
i am trying to create server audit but shows the below error.

CREATE SERVER AUDIT MyServerAudit
TO APPLICATION_LOG
WITH ( QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE);

Error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'SERVER'.
Msg 319, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 136, Level 15, State 1, Line 3
Cannot use a CONTINUE statement outside the scope of a WHILE statement.

Any one help me to configure audit in sqlserver 2008 throw SQL server management Studio.

Scott Whigham

Posted: Thursday, October 01, 2009 8:47:42 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 466
Points: 1,020
Where do you live?: Dallas, TX

The code is correct - are you sure you are on SQL Server 2008?

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.