Simple SQL problem

Mbyllur Postuar Jan 6, 2005 Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

I have a single instance SQL 2000 database server with 2 databases on it. These databases are called database1 and database2. I need to update rows in a table (table2) in Database2 with data from a view in Database1 (ViewA). The tables in Database1 which host the data for ViewA are updated via transactional replication from another server. Table2 in database2 has triggers which update clients at row level, so I think i have to maintain the structure of this table to preserve the triggers. Can I use transactional replication on the same server to replicate transactionally replicated tables? Should I use linked servers or distributed queries....? Is there such a thing as a distributed update query? Basically how can I achieve the above. correct solution will win $10. Many thanks.

## Deliverables

1) Working technical solution to the above problem. with pointers as to how to get configuration information if possible.

## Platform

Win2k Server SQL 2000

Inxhinieri MySQL PHP Arkitekturë softuerësh Testim Softuerësh SQL

ID Projekti: #3506514

Rreth projektit

3 propozimet Projekti në distancë Aktiv Jan 15, 2005

3 profesionistë freelancer dërguan një ofertë mesatare prej $9 për këtë punë

cartzlink

See private message.

$8.5 USD për 2 ditë
(90 Përshtypje)
5.6
alwildvw

See private message.

$8.5 USD për 2 ditë
(9 Përshtypje)
3.7
arif1vw

See private message.

$8.5 USD për 2 ditë
(3 Përshtypje)
2.5