Good morning,
In sql-server(7 or 2k)can a linked server have an alies or
a synonym?
I need to avoid the 4 part naming convention
(linkedserver.dbname.owner.object)when I refer to an
object on a liked server and use an alies/synynom for
the "linkedserver.dbname.owner" portion.
Is this doable in MS-SQL'
ThanX
ekEmil
I guess you could create a view for the linked server object. ie
CREATE VIEW BOB_VIEW
as
SELECT * FROM LinkedServer1.Northwind.dbo.BOB
"Emil" <anonymous@.discussions.microsoft.com> wrote in message
news:1757a01c448bf$467f2e70$a101280a@.phx
.gbl...
> Good morning,
> In sql-server(7 or 2k)can a linked server have an alies or
> a synonym?
> I need to avoid the 4 part naming convention
> (linkedserver.dbname.owner.object)when I refer to an
> object on a liked server and use an alies/synynom for
> the "linkedserver.dbname.owner" portion.
> Is this doable in MS-SQL'
> ThanX
> ek
No comments:
Post a Comment