How can i update multiple databases at the same time in SQL Server?

Question

I have 7 databases. Databases have same tables. I want to update all of them at the same time when i edit row or add new row. If one of transactions doesn't work , It will not be updated.

How can i update?

Answer 1

You can add all your servers/databases to one group in Registered servers pane (SQL Management Studio(2016): Ctrl + Alt + G to show it). Under local serves Groups.

Then press right button on a new group and select "New Query".

When you execute query it will run on all servers in selected group.