dave hants (5/8/2014)

---

bartedgerton (10/8/2013)

---

Basu's suggestion was right.

Here is my full query to list all DDL changes:

ALTER PROCEDURE [dbo].[SchemaChangesToday]

@dbName VARCHAR(128) = NULL

AS

BEGIN

DECLARE @filename nvarchar(1000);

-- Get the name of the current default trace

SELECT @filename = cast(value as nvarchar(1000))

FROM ::fn_trace_getinfo(default)

WHERE traceid = 1 and property = 2;

-- view current trace file

SELECT LoginName, HostName, ApplicationName, DatabaseName, ObjectName, sv.name [ObjectType], te.Name [Action], StartTime, ftg.TextData

FROM ::fn_trace_gettable(@filename, default) AS ftg

LEFT JOIN sys.trace_events AS te ON ftg.EventClass = te.trace_event_id

LEFT JOIN spt_values sv ON ftg.ObjectType = sv.number

WHERE (ftg.EventClass in (46,47,118,125,126,128,129,131,164,165,176,177,178))

and DatabaseName = case when @dbName is null then databasename else @dbName end

and DatabaseName != 'tempdb'

and EventSubClass = 0

ORDER BY ftg.StartTime desc;

END;

I think there may be duplicates in this result because of duplicate support values....

Regards, Dave