CODEWITHSUNDEEP
sqlsql-server-2008servicenotifications
babak
babak

Reputation: 155

Notification services in SQL Server 2008

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 ?

Upvotes: 1

Views: 2473

Answers (1)

Pradeep
Pradeep

Reputation: 3276

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

Upvotes: 2

Related Questions