1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
declare @path nvarchar(4000);
SELECT @path = Substring(PATH, 1, Len(PATH) - Charindex('\', Reverse(PATH))) +
'\log.trc'
FROM sys.traces
WHERE id = 1
SELECT substring(databasename,1,25) AS DatabaseName,
substring(e.name,1,40) AS eventname, TextData, EventClass,
substring(cat.name,1,20) AS [CategoryName],
starttime,
e.category_id,
substring(loginname,1,25) as loginname,
substring(hostname,1,25) as hostname,
servername,
applicationname
FROM ::fn_trace_gettable(@path, 0)
INNER JOIN sys.trace_events e
ON eventclass = trace_event_id
INNER JOIN sys.trace_categories AS cat
ON e.category_id = cat.category_id
--WHERE
--(
--(e.name like '%Shrink%' or TextData LIKE '%SHRINK%')
--/*OR
--(e.name like ( '%Grow%' ) or TextData LIKE '%Grow%')*/
--)
--AND EventClass <> 175 --AND DatabaseName = '*****'
ORDER BY starttime DESC |
Partager