This blog is going to have surfing, snowboarding, tech stuff and maybe some 'meaning of life' stuff if I'm feeling particularly stoked.

Tuesday, April 26, 2005

SQLDependency Update

Route 44: 6:45 Wallingford to Montlake Freeway Station
Route 242: 7:01 Montlake to Overlake

Listening: Feeder Pushing the Senses

I've updated my last post because it looks like my msdb was missing the SqlQueryNotificationService (I upgraded a SQL2000 installation - must have been that) and that's why I had to use the [http://etc] names.
Well this seems to work right up until SQL server tries to notify the caller of the change, at which point it generates an error saying that it could not find the service contract.
I presumed it needed the default (SqlQueryNotificationService) contract so I switched over to a fresh install of SQL2005 (making sure the SqlQueryNotificationService was there) and retraced my steps using SqlQueryNotificationService (e.g. GRANT SEND rights again) and it worked.

I have a feeling that the list of query restrictions will make SQLDependency almost unusable in the real world.