This example creates an entry for the local server named DOCS:
sp_addserver DOCS, local
This example creates an entry for a remote server named GATEWAY:
sp_addserver GATEWAY
To run a remote procedure such as sp_who on the GATEWAY server, execute either:
GATEWAY.sybsytemprocs.dbo.sp_who
or:
GATEWAY...sp_who
This example gives a remote server called MAIN_PRODUCTION the local alias “main:”
sp_addserver main, null, MAIN_PRODUCTION
The user can then enter:
main...sp_who
