[quote=“Jerry_H”]yes I am using a script. I want to insert data into 2 tables (Same name) but they are on 2 different servers. They both work if they are selected as the default database connection.
Is it possible to change the database connection in the script?[/quote]
Yes, the system.db scripting functions all take an optional database name parameter. See the user manual for more info.