Insert several databases simultaneously

Hi!

I would like to insert a record into table for many databases(that are alike). Does anyone know how to do this in SQL?

Thank you in advance!

One way is to use replication.

Another way is to use run multiple queries with the full database qualifier.

If all the databases are on the same server:

Insert into MyDatabase1.dbo.MyTable (Field1) values ('hello world');
Insert into MyDatabase2.dbo.MyTable (Field1) values ('hello world');
Insert into MyDatabase3.dbo.MyTable (Field1) values ('hello world')


If they are on different servers then you can create Linked Servers and the queries would look something like this:

Insert into MyDatabase1.dbo.MyTable (Field1) values ('hello world');
Insert into Myserver2.MyDatabase2.dbo.MyTable (Field1) values ('hello world');
Insert into MyServer3.MyDatabase3.dbo.MyTable (Field1) values ('hello world')