The table name is mis-formed. It should be in the form database.owner.table. In you case, just add an extra '.' but only if the table is owned by DBO in the other database.


>INSERT INTO DestinationDB..DestTable (location,[name],calltaker)
> SELECT object, ticket_number, username
> FROM inserted


-Mike