how to connect triggerwithout main server

[rupal2]

i create trigger in mainserver and connect it throuth local using linked server but if my main server is off then how can i run the trigger in local server without connecting main server

[Lost User]

Please post your question only once. If you make a mistake then just edit the original.

[Lost User]

rupal2 wrote:

trigger in mainserver

rupal2 wrote:

main server is off

= No chance to fire the trigger. The local server isn't going to clone everything that the mainserver has. If the linked server is down, then everything within that server is down too. Your options are relative limited; you could try to move the trigger to your local database, or turn on the main-server.

I are Troll :)