SQL Server 2008 Notification Services

re: SQL Server 2008 Notification Services

pc forum — Sun, 21 Dec 2008 19:10:02 GMT

Great post, explained really well and I could really understand. Thank you.

re: SQL Server 2008 Notification Services

Robert B — Mon, 19 Jan 2009 22:09:11 GMT

Andrew,

Great post. I'll post Microsoft Connect as well, but wanted to pick your brain for a moment if you'll allow it.

I have used SQL Notification to handle cache expiration notifications (or rather updating remote cache's when data changes at the source). This was a great technique that insured data did not become stale.

Do you have any ideas or have you seen any suggestions for how to achieve this type of "data changed event" notification in SQL Server 2008?

Thanks,

Robert

re: SQL Server 2008 Notification Services

Andrew_Fryer — Wed, 28 Jan 2009 19:33:33 GMT

Robert

Back form my holidays tomorrow(29 Jan), so can I give you a call to discuss?

Andrew

re: SQL Server 2008 Notification Services

Malcolm Rasool — Fri, 27 Feb 2009 01:03:48 GMT

would it be possible to share your response to Robert's query regarding remote cache management via notification service please?

re: SQL Server 2008 Notification Services

Andrew_Fryer — Mon, 02 Mar 2009 16:45:39 GMT

Malcolm

Robert didn't get back to me, so again feel free to call me e-mail me etc. as basically I need to know what you want ot use NS for

Andrew

re: SQL Server 2008 Notification Services

Cheeso — Mon, 18 May 2009 16:29:58 GMT

Andrew, I assume the SqlNotificationRequest class in ADO.NET is dependent upon Notification Services. can you confirm? And What is the replacement approach for a .NET app to get notified of new rows in a Change Tracking table? (Effectively, getting notified of changes in the tracked table). can you post something to http://stackoverflow.com/questions/877273/change-notification-with-sql-server-2008 ?