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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL trigger to output to an Access Database?
- Thread starter StevenK
- Start date
If there is, I wouldn't recommend doing it. That would be a killer for your performance.
However, if you absolutely must use a trigger (rather than using a nightly DTS / SSIS / BCP job) to do it, your best bet is to used Linked Servers (look that term up in Books Online) to connect the servers and then use four dot notation (Server.Database.Owner.Table) to reference all the appropriate tables.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
However, if you absolutely must use a trigger (rather than using a nightly DTS / SSIS / BCP job) to do it, your best bet is to used Linked Servers (look that term up in Books Online) to connect the servers and then use four dot notation (Server.Database.Owner.Table) to reference all the appropriate tables.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Status
Similar threads
- Locked
- Question
