on insert trigger and a linked server?

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.
thanksdarwin
Yes, but why would you want to use a trigger?
"darwin" <darwin@.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|||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
"Uri Dimant" wrote:

> darwin
> Yes, but why would you want to use a trigger?
>
> "darwin" <darwin@.discussions.microsoft.com> wrote in message
> news:AD6E0624-1BB6-49A1-B187-DD6424FFFD1F@.microsoft.com...
>
>|||Transactional replication is an option:
http://msdn.microsoft.com/library/d...r />
_7syn.asp
ML
http://milambda.blogspot.com/