Hello All, We are going to start new batch from next week. message/call or mail us for more details.

18 August 2012

Find out who modified an object in SQL Server


SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_id
Where T.id = 1 And
E.name = 'Object:Altered' and ObjectName like '%UAC_AdminAccess%'

2 comments: