Basic TSQL SQL Server

Select Between Multiple Instances

By David Speight / August 20, 2022

Here is an example demonstrating how to SELECT between two separate SQL Instances.

This assumes you have the correct permissions set up between the two servers.

:CONNECT SQLSERVER1 -U MyLoginName -P MyPassword 
GO
SELECT * FROM sys.databases
GO

You may also like