1

I have a SQL Server database and several clients that use it (via a C# application). In the database I have a table and each record of this table has a field (status flag) which is changed by clients on run time. Now when a client change the status of a record in the database I want SQL Server to inform the other clients about this change immediately.

After searching, I found that Notification Services (NS) in SQL Server 2005 is suitable for this scenario, but I heard that NS is not supported in SQL Server 2008.

Now, what is the substitute of NS in SQL Server 2008 ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
babak
  • 155
  • 1
  • 1
  • 14

1 Answers1

2

Well SQLDependency is still around. This SO thread is discussing the options in more detail.

Community
  • 1
  • 1
Pradeep
  • 3,258
  • 1
  • 23
  • 36
  • Thank you for answer. I used it and my problem was solved. But apparently in this method you can't notify wich change has been done, SQL only notifys a change is occured. – babak Mar 14 '11 at 10:29