on insert trigger and a linked server?

20 Jan 2006 12:40 AM

darwin

Hi all
Is it possiable to use an on insert trigger to insert the same record into
another server (linked)?

Any hints or issues with this would be appreciated.
thanks

20 Jan 2006 4:29 AM

Uri Dimant

darwin
Yes, but why would you want to use a trigger?

Show quote

"darwin" <dar***@discussions.microsoft.com> wrote in message
news:AD6E0624-1BB6-49A1-B187-DD6424FFFD1F@microsoft.com...
> Hi all
> Is it possiable to use an on insert trigger to insert the same record into
> another server (linked)?
>
> Any hints or issues with this would be appreciated.
> thanks

20 Jan 2006 2:04 PM

darwin

Hi

When a new record is inserted into the first table we need a copy of that
record sent to a second table on a different server (linked), in near real
time.
What is the solution you are thinking of?
thks

Show quote

"Uri Dimant" wrote:

> darwin
> Yes, but why would you want to use a trigger?
>
>
> "darwin" <dar***@discussions.microsoft.com> wrote in message
> news:AD6E0624-1BB6-49A1-B187-DD6424FFFD1F@microsoft.com...
> > Hi all
> > Is it possiable to use an on insert trigger to insert the same record into
> > another server (linked)?
> >
> > Any hints or issues with this would be appreciated.
> > thanks
>
>
>

20 Jan 2006 2:12 PM

ML

Transactional replication is an option: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/repltypes_7syn.asp

ML

---
http://milambda.blogspot.com/