Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I am trying to create a Logon trigger, in SQL SERVER but 

EVENTDATA().value ('(/EVENT_INSTANCE/ClientHost)[1]', 'NVARCHAR(15)')

is returning NULL values. Why So ?

share|improve this question
That looks correct to me. Can you post your whole trigger in your question? – Thomas Stringer Jul 18 '12 at 12:54
Thanks SHARK, you were correct, problem was on my syntax side. Thanks for your time. – aasim.abdullah Jul 18 '12 at 13:31
No problem, glad to help. – Thomas Stringer Jul 18 '12 at 13:35

closed as too localized by jcolebrand♦ Jul 18 '12 at 14:59

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.