Connect two database servers with the same SQL statement

In the SQL Server Query analyzer, one SQL statement is used to connect two database servers.

In the SQL Server Query analyzer, one SQL statement is used to connect two database servers.

Exec sp_addrole server 'logical name', '', 'sqloledb', 'remote server name or IP address'
Exec sp_add1_srvlogin 'logical name', 'false', null, 'username', 'Password'
Go

After the creation is complete, you can use it normally.

Select * from logical name. Database Name. Dbo. The table name is a complete SQL statement.

Delete the created virtual connection after use.

Exec sp_dropserver 'logical name', 'droplogins'