Just updated Lowell's code with my table and columns....in my previous post you can see table structure....please let me know your thoughts....

CreateTRIGGER TR_NOTIFICATIONS

ON ConfigSet FOR Update, insert, delete

AS

BEGIN

SET NOCOUNT...

Yes i have updated it and create trigger in my table. Deleted, inserted the record ...same issue....getting email but it has nothing in it except the subject

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)...

Thanks you very much guys...i will give a try with Lowell code and let you know the status...

the table that we are creating trigger wont be having more updates..i'm not much into coding..please help me on this...any idea and code will be appreciated.

Thanks

I think the Principal server is unable to access the Mirror server Log path or Vice Versa...I got the same issue when I try to setup mirroring. Please check that...