How to Link Server

Hi

Is there a workaround how to create a link server?

Thanks

sp_addlinkedserver [ @.server = ] 'server'
[ , [ @.srvproduct = ] 'product_name' ]
[ , [ @.provider = ] 'provider_name' ]
[ , [ @.datasrc = ] 'data_source' ]
[ , [ @.location = ] 'location' ]
[ , [ @.provstr = ] 'provider_string' ]
[ , [ @.catalog = ] 'catalog' ]

Hope this helps.

OR

1. Go to Enterprise Manager
2. Select Server
3. Select Security
4 Go to Linked Servers
5. Right Click on Link Server and select New Linked Server
6. Enter required details and press OK