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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

distributed queries from triggers

Status
Not open for further replies.
surzycki

surzycki

IS-IT--Management
Feb 9, 2002
62
FR
Hello all,

I was having problems executing a distributed query from a trigger using the OPENQUERY or OPENSOURCE syntax. Is this because it is not possible??

Thanks for any insight

Stefan
 
Sort by date Sort by votes
Try executing the statement in QA logged in as the same user who is executing the trigger. If it works then remote queries may not work in triggers, if it doesn't it might be a permission issue...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
250
bharons
bharons
grnzbra
  • Locked
  • Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY 1
Replies
4
Views
344
JeffModen
JeffModen
Auguy
  • Locked
  • Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
104
Auguy
Auguy
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
165
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question
How to import plain text from Word doc to SQL 1
Replies
4
Views
156
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top