|Previous Top Next|
With the Microsoft SQL Server Synonym Editor, you can create synonyms on the current server or a linked server.
In the Server drop down box, select the empty spot if you want to define a synonym for an object on the current server. All other boxes will be drop down boxes and you can select your object.
Selecting an object at the current server
If you keep the current database, you can simply select an object from the drop down lists. If you select another database, you have to enter the object name by hand.
Selecting an object at a remote Linked Server
If you choose to create a synonym for an object at a linked server, you have to enter all details by hand.