SQL Service Broker Problem with date

Question

Hi All

I use the SQL Service Broker to notify me when a row is inserted in a SQL table.

The SqlDependency command text as follwing

SELECT Email from dbo.CEM where Date_CEM = '1/20/2008 12:00:00 AM'

As you see there is a column its datatype is datetime (Date_CEM), when I am using a select statement same as shown I am having a problem, which is : SqlDependency onchange event is invoked continuously and cannot be stopped wherever the value of the Email column is changed or not, but when I tried to use another select statement that not contains a datetime column in the condition the event is invoked correctly (only when the value is changed of the Email column)

Can anybody help me

Answer 1

I had to do something similar to this

CONVERT

 

(VARCHAR, GETDATE(), 126) + 'Z' AS LogDateTime, -- format date for xml

Answer 2

I think you did not try this solution before you send it.

Thanks

Answer 3

Did you ever find a solution to your problem?  I am currently having this issue.

---

Database Engineer