• When i execute this statement i am getting the below error message:

    INSERT INTO dbo.[DB Mirroring State Changes] (

    [Event Time],

    [Event Description],

    [New State],

    [Database] )

    VALUES (

    $(ESCAPE_NONE(WMI(StartTime))),

    $(ESCAPE_NONE(WMI(TextData))),

    $(ESCAPE_NONE(WMI(State))),

    $(ESCAPE_NONE(WMI(DatabaseName))))

    Output:

    Msg 102, Level 15, State 1, Line 7

    Incorrect syntax near '('.