Linked Server Alias?

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."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