create trigger on different databases

Question

0.00/5 (No votes)

See more:

hi

i create trigger for insert within one database
But i need to create insert trigger for inserting values to the table on one database
it reflect to the same table on another database plz answer quckly

(i m using sql server 2005)

Thanks Regards,

Posted 2-Apr-12 2:15am

gopi1987

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)

Not Active · Answer 1 · 2012-04-02T02:27:00

Solution 1

AKAIK you can't create triggers across databases. The tiggers are only valid for the database created in. If you want cross database communication you may want to look into Service Broker

Posted 2-Apr-12 2:27am

Not Active

Comments

gopi1987 17-Apr-12 9:37am

i think you mean that diff provider like access,sql,
i know its not possible to create trigger for diff provider.

i dont want this
i need to know, i have two databases and a table placed in both the databases
now i insert a record to one table first database,the trigger insert the same record to same table placed in second database,

please if you know send the code

Thanks and Regards,

[no name] 17-Apr-12 18:35pm

Don't ask for anyone to send you code. It's rude and shows no effort on your part.

No I don't mean different providers. You cannot create a trigger in one database the works on another database on the server or instance. If you think about it you would understand why. As I said, Service Broker is available with SQL Server. I would suggest you do some research.