Hi, i wrote VC Program Using SQLServer for database application;

My application has several client programs that connected to one sqlserver database; 

I want each client side aware about chages immediately that other client programs affect on database;(insert , update and delete);

i dont want check Database in loop neither i dont want use socket programming directly; is there any way that server send it’s chenges to client and client also recive changes from server automaticly ; 

Bests

Hamid

Report Abuse

Today, 12:09 PM UTC

Joe Webb

ModeratorMVP

Posts 657

Re: How client site can aware about chenges in Database;

Was this post helpful ?

Check out Service Broker for SQL Server 2005. It’s has Query Notifications that can notify a client app when a resultset has changed. HTH…Joe

Bookmark:Digg Del.icio.us Reddit