Activity overview
Latest activity by IanJerrett
I forgot to add the code, although not the most eloquent. SELECT id,PostTime ,eventdata.value('(/EVENT_INSTANCE/EventType/.)[1]', 'varchar(50)') as EventType ,eventdata.value('(/EVENT_INSTANCE/ObjectName/.)[1]', 'varchar(max)') as [ObjectName] ,eventdata.value('(/EVENT_INSTANCE/SchemaName/.)[1]', 'varchar(max)') as SchemaName ,eventdata.value('(/EVENT_INSTANCE/ObjectType/.)[1]', 'varchar(max)') as [ObjectType] ,eventdata.value('(/EVENT_INSTANCE/ServerName/.)[1]', 'varchar(max)') as ServerName ,eventdata.value('(/EVENT_INSTANCE/LoginName/.)[1]', 'varchar(max)') as LoginName ,eventdata.value('(/EVENT_INSTANCE/UserName/.)[1]', 'varchar(max)') as UserName ,eventdata.value('(/EVENT_INSTANCE/DatabaseName/.)[1]', 'varchar(max)') as DatabaseName ,eventdata.value('(/EVENT_INSTANCE/TSQLCommand/.)[1]', 'varchar(max)')as [TSQL] from SQLLighthouse.DDL_Events ORDER BY PostTime DESC / comments
I forgot to add the code, although not the most eloquent.SELECT id,PostTime ,eventdata.value('(/EVENT_INSTANCE/EventType/.)[1]', 'varchar(50)') as EventType ,eventdata.value('(/EVENT_INST...
I have just queried the xml in the eventdata column within the Redgate database. This is fundamentally where DLM gets the data from to display. the catch is you have to connect to each server/listener that DLM is monitoring. It would be much better if Redgate would do two things: 1. Provide a summary of changes before you drill into the detail, the same way you do in SQL Compare. 2. Provide a report that summarises all changes made with the option to drill through on any change / comments
I have just queried the xml in the eventdata column within the Redgate database. This is fundamentally where DLM gets the data from to display. the catch is you have to connect to each server/list...