Insert same data in two different database simultaneously

Hi Nilesh can you provide me link to create link server using Sql Server step by step

I assume both of them are SQL Servers

if so, you can create a link between those, using "linked servers" feature

on insert in any one server, use "after insert" trigger on table to insert on another server table

You can write a procedure for it.

Create Proc [Procedure_Name]
@Param1 datatype,
@Param2 datatype,
@Param3 datatype
as
Begin
Insert into [DatabaseName].[SchemaName].[TableName] values(@Param1,@Param2,@Param3)
Insert into [SecondDatabaseName].[SecondSchemaName].[SecondTableName] values(@Param1,@Param2,@Param3)
End

You can try

There is one concept as SQL Replication, where you can create more database connection. Here I have pasted the links, kindly have a look,

1) https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication

2) https://stackoverflow.com/questions/153988/how-can-i-copy-data-records-between-two-instances-of-an-sqlserver-database

Hope these may helps you. thanks in advance.