how to write a sql trigger to fire any operation in multiple systems DB and In case of fail over how to can we set a schedule a time to fire operations.

Question

0.00/5 (No votes)

See more:

I have to write a trigger in sql server 2005
I have 5 machines with sql server installed on each machine . One of them is working as a server , if any operation is happening in server machine db then it should reflect in all machine .
In case of any network issue , it should work as a scheduler task in each hour .

Posted 19-May-13 13:17pm

lalit.mca2006

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Damian S_ · Answer 1 · 2013-05-19T16:39:00

Solution 1

Your question can be solved using SQL Server Replication. A great place for you to start is here: http://msdn.microsoft.com/library/ms166367.aspx[^]

Posted 19-May-13 16:39pm

_Damian S_

Comments

lalit.mca2006 19-May-13 23:01pm

its ok, but i have to do it periodically. It should run automatically .

_Damian S_ 19-May-13 23:20pm

Did you read the article? What you have described in your question is precisely what replication exists for.