I am trying to create a Logon trigger, in SQL SERVER but
EVENTDATA().value ('(/EVENT_INSTANCE/ClientHost)', 'NVARCHAR(15)')
is returning NULL values. Why So ?
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.