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