Currently I have two SQL server sitting in two different machine. I call then SQL1 and SQL2. There are database DB1 in SQL1, database DB2 in SQL2.
Now I connect to SQL1.DB1, can I write a query like "select * from SQL2.DB2..table2 " to get data from the tables in SQL2, DB2?
Now I connect to SQL1.DB1, can I write a query like "select * from SQL2.DB2..table2 " to get data from the tables in SQL2, DB2?