By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,344 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Trigger on Replicated table from another Database

P: 1
Hi,
I have a problem trying to update a table I replicated from a master table "Details" in database "BRC" on server "Comp24" on to my database "BRCTM" on my local server "Comp28" ,
as in changes made to the master table
"Details"[database "BRC" on server "Comp24"]
should be reflected in the replicated version
"Details" [database "BRCTM" on my local server "Comp28"],
but the reverse should not be possible
Could I please get some guidance as to how to perform this operation ?
Please give the SQL trigger syntax for this operation.
I am using MS SQL Server 2000 Developer Edition
Regards
Feb 6 '08 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
if you don't need it in real time, why not schedule a job instead that will backup the database and restore it on the local one, overwritting the local one.

if you need it in real time, try replication

-- ck
Feb 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.