Se poate. Urmatorul cod mie personal imi functioneaza:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| USE [master]
GO
CREATE SERVER AUDIT [MySecurityAudit]
TO FILE
( FILEPATH = N'D:\'
,MAXSIZE = 0 MB
,MAX_ROLLOVER_FILES = 2147483647
,RESERVE_DISK_SPACE = OFF
)
WITH
( QUEUE_DELAY = 1000
,ON_FAILURE = CONTINUE
,AUDIT_GUID = 'a117a005-c827-4277-bd3a-374243af7b99'
)
GO |
1
2
3
4
5
6
7
8
| USE [DemoDB]
GO
CREATE DATABASE AUDIT SPECIFICATION [DB_Audit]
FOR SERVER AUDIT [MySecurityAudit]
ADD (EXECUTE ON OBJECT::[dbo].[usp_Test] BY [User1])
WITH (STATE = ON)
GO |
Se poate vedea in imagine ca este capturata si valoarea parametrului:
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro