• I'm not able to get this done....here is my table structure...

    CREATE TABLE xxxxx (

    [ConfigSetID] [int] IDENTITY(1,1) NOT NULL,

    [Name] [nvarchar](255) NOT NULL,

    [Version] [smallint] NOT NULL,

    [OverrideID] [int] NOT NULL,

    [Timestamp] [binary](8) NULL

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    GO

    ALTER TABLE [dbo].[xxxxx] ADD DEFAULT ('') FOR [Name]

    GO

    ALTER TABLE [dbo].[xxxxx] ADD DEFAULT ((0)) FOR [Version]

    GO

    ALTER TABLE [dbo].[xxxxx] ADD DEFAULT ((0)) FOR [OverrideID]

    GO

    ALTER TABLE [dbo].[xxxxx] ADD DEFAULT ((0)) FOR [Timestamp]

    GO

    i need to create a trigger that tracks any changes on this table and send email to team when there is any update.

    i'm getting rid of EVENTDATA, trying to implment inserted and deleted tables ...

    Please help me on this...

    Thanks in advance....