I'm using SqlDependency to get changes of my records in sql server.
Select statement is based on date, and the store procedure is like this

```
Select dbo.table.dt where dbo.table.dt = @dt

```

Where @dt is passed as date parameter to stored procedure. with value DateTime.Now.Date

I want to select today records, but when the date changes from '7/14/2014' to '7/15/2014'
the records aren't changed.