Notifications (again)

[LHSoft]

Hello,
a table is set to get and send notifications, everything works fine unless there is a date in the SQL WHERE section, standalone or comined, f.x.

select * from MoStmKun WHERE day='03.06.2013'

.

So, in this case, I get errormessage: Statement does not support notifications, but indeed it still sends notifications but does not recieve.

Is this a bug or standard?

best regards
Hans

[AndreyZ]

The point is that notifications has several restrictions for the SELECT statement, you can find them here (in the "Supported SELECT Statements" section): http://msdn.microsoft.com/en-us/library ... l.90).aspx . Make sure, your SELECT statement meats all of notifications requirements.