General information
Forum:
Microsoft SQL Server
Title:
Reference a table in another Database (trigger)
All,
I am attempting to push records to another DB using an insert trigger.CREATE
TRIGGER Source_ins_tr ON [Source]
FOR INSERT
AS
INSERT INTO DestinationDB.DestTable(location,[name],calltaker)
SELECT object, ticket_number, username
FROM inserted
This doesn't work. How should I go about doing this?
poffield@liberty.edu
Thanks in advance
Phil
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only