MS SQL Server - Linked Server Alias?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Linked Server Alias?

Dave

2006-10-24, 6:31 pm

Is it possible to create an alias for a linked server? For instance when I
reference a linked server today I have to specify
server.database.schema.table. I would like to be able to create an alias
for the linked server so I could just reference it as alias.table.

David Browne

2006-10-24, 6:31 pm

"Dave" <dave@aol.com> wrote in message news:mZYQg.219$8O1.88@trnddc04...
> Is it possible to create an alias for a linked server? For instance when
> I reference a linked server today I have to specify
> server.database.schema.table. I would like to be able to create an alias
> for the linked server so I could just reference it as alias.table.
>

In 2005, you can accomplish this with schemas and synonyms.

EG

create schema SalesDB
go
create synonym SalesDB.MyTable
for [SALESPROD09].[SalesMaster].Dbo.MyTable

David

Sponsored Links