I have a table tbl_User(ID,UserName,UserPassword,UserStatus).

when some value insert into tbl_User the log data should insert in to another database table. How can I achieve this ???

Is any new features related to trigger that can be done in new database from one???

• Edited by Navaraj subedi 1 hour 6 minutes ago

You can INSERT into a different database from a trigger. Just use 3 parts naming:

loggingdb.dbo.loggingtable

Instead of dbo, different schema can be used.