Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Linked Server Name

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2004-05-12 : 17:24:10
My linked server name shows up as the full domain name in QA.

Is there a way to create a shortcut name? (I use EM to create the Linked Server)

Sam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-12 : 17:59:40
You could create an alias on the database server. Your linked server would reference the alias. Key thing is that the alias is on the database server and not on the client machine.

Tara
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-05-12 : 19:55:20
Thank you Tara..... Works great.

And congrats on your passing 6000 !!

Sam
Go to Top of Page
   

- Advertisement -