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
sql-server
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