Can you create a linked server in SQL Server and then refer to it with an alias

Posted by Craig HB on Stack Overflow See other posts from Stack Overflow or by Craig HB
Published on 2010-06-03T15:46:57Z Indexed on 2010/06/16 4:02 UTC
Read the original article Hit count: 264

Filed under:

Can you create a linked server in SQL Server 2008 and then refer to it with an alias.

So, I create a linked server to "SalesServer", but I give it the alias "Sales", so I can use it like this:

SELECT * FROM Sales.DB1.dbo.DailySales

© Stack Overflow or respective owner

Related posts about sql-server