Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trigger and linked server

Status
Not open for further replies.
darwin101

darwin101

Programmer
Joined
Mar 7, 2001
Messages
156
Location
US
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
 
Sort by date Sort by votes
Yes you can easily do this. However keep in mind that if the server you are linked to you won't be able to insert records into your main table until the other server comes back up.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
964
Chriss Miller
C
V
  • Locked
  • Question Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
1K
Volvere
V
peac3
  • Locked
  • Question Question
Gaps and islands
Replies
8
Views
929
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
921
Andrzejek
Andrzejek
Colin Burton
  • Locked
  • Question Question
Determine if a file exists on s different server to the SQL Server
Replies
2
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top