SELECT	top 200
		te.name, 
		ft.SPID,
		ft.LoginName,
		ft.Hostname,
		ft.ClientProcessID,
		ft.DatabaseName, 
		ft.FileName, 
		ft.StartTime, 
		dateadd(ms,ft.Duration/1000,ft.StartTime) [FinishTime],
		ft.ApplicationName ,
		ft.ObjectID,
		ft.Duration/1000./1000 [Duration (s)],
	ft.TextData,
	ft.RoleName,
	ft.TargetUserName,
	ft.TargetLoginName
FROM sys.traces st CROSS Apply
	::fn_trace_gettable(left(st.path,len(st.path)-charindex('_',reverse(st.path)))+right(st.path,4), st.max_files) AS ft 
INNER JOIN sys.trace_events AS te ON ft.EventClass = te.trace_event_id 
WHERE 
	te.name LIKE '%Grow'  
	and st.is_default=1 
	and st.status=1
ORDER BY ft.StartTime desc;