How can I reflect That Table?most... Urgent

[rite2sekhar]

Hi
I had 3 servers With the same database
In one machine(Server) I have a execute a procedure ,with that execution finally one table will be updated.

This updation should be reflected in rest of two machines(Servers).

For this is there any snop shot or materialized views ..... some good concept is available in sqlserver?
If Yes Please give me with an example
its most most... Urgent

[arunraj_c]

Hi,

You can setup Database Mirroring. Database Mirroring option is available in SQL Server 2005 Enterprise Edition.

Please look into the following article for further details:

http://www.microsoft.com/technet/pro.../dbmirror.mspx