Description of columns for table : [dbo.RG_AllObjects_v3]

umeshgopal

Does anyone know the full description of the columns of the following changelog table.
I specifically need clarification on :
EntryDateTime
ModifyDate

Description of columns for table : [dbo.RG_AllObjects_v3]

AllObjectsID
EntryDateTime
DatabaseID
ObjectType
ObjectID
SchemaName
ObjectName
ModifyDate
ParentObjectID
ParentObjectName
ParentObjectType
TypeOfAction
Matched
UserName

Rob C

Hi,

EntryDateTime is the UTC time that the action gets logged and ModifyDate is the local time when the action was taken.

For more detailed information you can examine the dbo.RG_WhatsChanged_v3 stored procedure.

hnoor0033

EntryDateTime is the UTC time that the action gets logged and ModifyDate is the local time when the action was taken.