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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the 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