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 '('.