The issue you presented regards an insert operation.

a query is a different thing - one might think you are referring to distributed query on multiple servers for performance.

an insert operation is generally not a one time operation and if you are adding records to a table and need to insert the same records to 50 other db's than I would use replication on that table and replicate it to all other servers. you have a built in module in sql server that does the work - why develop it yourself ?