Comments
-
Exactly what I needed, thanks. The query I actually ended up using was SELECT TOP 1000 LogDateTime,AlertName,L.ObjectType,ObjectName,ActionType,Message FROM [dbo].[AlertLog] as L, [dbo].[AlertDefinitions] as D WHERE L.AlertDefId = D.AlertDefId
