A union of curiosity and data science

Knowledgebase and brain dump of a database engineer

Linked Servers : SQL Server

Linked Servers are in your object explorer. 

1. SQL Server to SQL Server:

Jump to step 3.

2. SQL Server to SQL Server : Alias

3. Set the Security Context:


Query the server : select * from <[mylinkedserveralias]>.<database>.<owner>.<object>


Add comment