Inserted triggers, when a table inserts data, inserts data into another table

Sometimes, when you have multiple databases on a server and you need to insert data into a table in one of the databases,

Inserts data into the table of another data at the same time.

Triggers and synonyms can be used (the method of creating synonyms is omitted),

When inserting data in a table in a database, insert data into the table of another database at the same time.

The trigger code is as follows:

Create TriggerUserinserttrigger on [User] for Insert as begin  begin  Insert  intoUsertab (Userid,useraccount,userpassword,username,organizationid)Selectinserted. Userid,inserted. Useraccount,inserted. Userpassword,inserted. UserName, Inserted.organizationid frominserted; EndEnd

The table [user] is the user table in the first database, and the second table Usertab is the table in the second database.
A synonym for the usertab name is established in the first database to access the second database when the first database is connected.

Inserted triggers, when a table inserts data, inserts data into another table