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/

Ole DB Example For Windows Mobile 5.0

Dear All:

Is there a tutorial for WM5.0 to connect to SQL CE 3.0 using Ole DB using the headers:

#include "ca_merge30.h"

#include "ssceoledb30.h"

#include "ssceerr30.h"

The example Northwind at "Sql Mobile 5.0" doesn't works with WM5.0 SDK, due to imcompatibility issues. It works with the WM2003 sdk, but i'm programming in native c++ for WM5 devices.

I'm using the header from SQL Everywhere.

Thanks.

Alfredo Mendiola Loyola

Lima Perú

Please look at the KB articles

http://support.microsoft.com/default.aspx?scid=kb;en-us;914174&sd=rss&spid=2852

and the following post on this forum

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=313150&SiteID=1

Thanks

Arun