i have two data base in two sql server instance and different computers and different places over the internet.
I can create a stored procedure that does a select of a table from a database of a computer, and then insert the table in another database of another computer?
SELECT * FROM SERVER1.DATABASE1.dbo.TABLE1
after prepare and insert in the other computer, SERVER2.DATABASE2.dbo.TABLE2
thanks in advanced
View Complete Post