accessing another server

[zuza]

dear all,

I want to accees a table from Query analyzer which is in another server - they're in the same domain/network (both of the servers). OK error is telling me 'Execute sp_addlinkedserver to add the server to sysservers.' I found the Stored Procedure - "sp_addlinkedserver", but I can not execute it in order to Add this server into sysservers table. How do I execute this procedure?

rgds,
ZuZa.

 

[nigelrivett]

You can add a linked server from enterprise manager under security but you will need permission to do it.

What happens when you try to execute sp_addlinkedserver?

You can also use openrowset to execute a query on remote server without a linked server by specifying the connection info in the query.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.