Server.DataBase alias in SQL Server 2008

Question

I've searched for this in quite a few areas, but haven't found a crystal clear answer to this.

I am working with multiple database servers and am consistently writing out [ServerName].[databasename].dbo.TableName. I know you can alias a table, but I can't find a definite answer on server and database.

Is it possible to create an alias that allows me to call the alias rather than calling the entire [ServerName].[databasename].dbo.TableName?

As an example: Server Name: SQL01 Database name: Client Desired Alias: Client

Sample table name on SQL01.Client: Contact

From SQL02, can I call Client.Contact like SELECT * FROM Client.Contact rather than having to write SELECT * FROM [SQL01].Client.dbo.Contact?

take a look here: stackoverflow.com/questions/6555646/…

user1293068
– user1293068

2012-07-16 15:14:53 +00:00
Commented Jul 16, 2012 at 15:14 — user1293068
– user1293068, Commented Jul 16, 2012 at 15:14
Where do you want this Alias to be visible from?

RBarryYoung
– RBarryYoung

2012-07-16 15:17:35 +00:00
Commented Jul 16, 2012 at 15:17 — RBarryYoung
– RBarryYoung, Commented Jul 16, 2012 at 15:17

Pondlife · Accepted Answer · 2012-07-16 20:15:02Z

1

If you haven't already come across it, the key word you're looking for is "synonym", and the documentation describes exactly the scenario you're interested in. So yes, it is possible.

answered Jul 16, 2012 at 20:15

Pondlife

16.3k6 gold badges40 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Server.DataBase alias in SQL Server 2008

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related