Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Sql Server 2008 R2 notify client application

Answered Sql Server 2008 R2 notify client application

  • Monday, May 16, 2011 8:19 PM
     
     
    Sign In to Vote
    0

    Which is the way to go to notify a client application that specific rows changed (without using polling and timestamp)?

    Notification Services are deprecated so they are no option in case of Sql Server 2008.

    I heard of another MS technology integrated with Sql Server 2008 R2 called Stream Insight which may suit the requirements.

    Which are the options - MS and non-MS - as long as it's connected to a Sql Server 2008 R2 database?

     

All Replies

  • Wednesday, May 18, 2011 7:12 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Macarie,

    Take a look at SQL Server Extended Events which is introduced in SQL Server 2008, see: http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.100).aspx.

    Hope this helps.

    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.