data synchronization

hi can anyone help me. i have two servers (ms sql) located at different
locations with one having a regularlly tran data. i need to synchronize
these two server at real time. I want to do this using a procedure. how
I can i do it?

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
    (microsoft.public.security)
  • Re: Time service driving me crazy!!
    ... Computers that are members of domain (client PCs and servers) use domain ... holding PDC Emulator FSMO role to synchronize time with. ... How To Synchronize the Time with the Windows Time Service in Windows XP ...
    (microsoft.public.windows.server.general)