Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @current VARCHAR(500);
- DECLARE @start VARCHAR(500);
- DECLARE @indx INT;
- SELECT
- @current = path
- FROM
- sys.traces
- WHERE
- is_default = 1;
- SET @current = REVERSE(@current)
- SELECT @indx = PATINDEX('%\%', @current)
- SET @current = REVERSE(@current)
- SET @start = LEFT(@current, LEN(@current) - @indx) + '\log.trc';
- SELECT
- CASE EventClass
- WHEN 46 THEN 'Object:Created'
- WHEN 47 THEN 'Object:Deleted'
- WHEN 164 THEN 'Object:Altered'
- END,
- DatabaseName,
- ObjectName,
- HostName,
- ApplicationName,
- LoginName,
- StartTime
- FROM::fn_trace_gettable(@start, DEFAULT)
- WHERE
- EventClass IN (46,47,164) AND EventSubclass = 0 AND DatabaseID <> 2
- ORDER BY
- StartTime DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement