June 10, 2014 at 6:48 am
I'm creating an audit specification in SQL 2008 R2 and I can't find the list of available predicates to filter on.
Where can I find the list of filter options such as database_name, server_name, user_id, table_name? See example
below which doesn't like the "application_name" syntax.
USE [master]
GO
CREATE SERVER AUDIT [Audit_Msaccess]
TO FILE
(FILEPATH = N'H:\'
,MAXSIZE = 2 MB
,MAX_FILES = 100
,RESERVE_DISK_SPACE = OFF
)
WITH
(QUEUE_DELAY = 1000
,ON_FAILURE = CONTINUE
)
WHERE application_name = 'MSACCESS'
GO
June 10, 2014 at 11:05 am
According to this blog post you can only audit on columns returned by sys.fn_get_audit_file and that is only 2012+. There are no predicate on Server Audits before 2012.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply