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