Insert Trigger

Is it possible for an insert trigger to trigger an action on another
instance of SQL Server?Can you elaborate more on this ?
From one database you can access objects from another database using the 3
part name (<DB Name>.<Owner>.<Object Name>) ... I hope this would be of some
help ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"CR" <jilesjilesjse@.jilesjsilessef> wrote in message
news:O8PAvG5dDHA.1772@.TK2MSFTNGP10.phx.gbl...
> Is it possible for an insert trigger to trigger an action on another
> instance of SQL Server?
>|||One option would be: inside a trigger run an insert statement on the table
of another server (using linked server) . This table (of another server)
will have an insert trigger which will trigger the required event as soon as
a row is inserted into it thorugh another server.
- Vishal
"CR" <jilesjilesjse@.jilesjsilessef> wrote in message
news:O8PAvG5dDHA.1772@.TK2MSFTNGP10.phx.gbl...
> Is it possible for an insert trigger to trigger an action on another
> instance of SQL Server?
>|||Thanks both Vinodk & Vishal. I think that linked servers is what I need to
do to accomplish this. The 3-part name works, but I think only for
databases on the same instance of SQL Server.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:%23Jz34j5dDHA.3128@.TK2MSFTNGP09.phx.gbl...
> Can you elaborate more on this ?
> From one database you can access objects from another database using the 3
> part name (<DB Name>.<Owner>.<Object Name>) ... I hope this would be of
some
> help ...
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "CR" <jilesjilesjse@.jilesjsilessef> wrote in message
> news:O8PAvG5dDHA.1772@.TK2MSFTNGP10.phx.gbl...
> > Is it possible for an insert trigger to trigger an action on another
> > instance of SQL Server?
> >
> >
>|||> The 3-part name works, but I think only for
> databases on the same instance of SQL Server.
Yup ... Else you need to resort to Vishals option of using a linked Server
...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"CR" <jilesjilesjse@.jilesjsilessef> wrote in message
news:OJwiF$HeDHA.1680@.TK2MSFTNGP09.phx.gbl...
> Thanks both Vinodk & Vishal. I think that linked servers is what I need
to
> do to accomplish this. The 3-part name works, but I think only for
> databases on the same instance of SQL Server.
> "Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
> news:%23Jz34j5dDHA.3128@.TK2MSFTNGP09.phx.gbl...
> > Can you elaborate more on this ?
> >
> > From one database you can access objects from another database using the
3
> > part name (<DB Name>.<Owner>.<Object Name>) ... I hope this would be of
> some
> > help ...
> >
> > --
> > HTH,
> > Vinod Kumar
> > MCSE, DBA, MCAD
> > http://www.extremeexperts.com
> >
> >
> > "CR" <jilesjilesjse@.jilesjsilessef> wrote in message
> > news:O8PAvG5dDHA.1772@.TK2MSFTNGP10.phx.gbl...
> > > Is it possible for an insert trigger to trigger an action on another
> > > instance of SQL Server?
> > >
> > >
> >
> >
>