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 Development (2000)  Accesing Remote Server

Author  Topic  Seingalt Starting Member 1 Post Posted - 2001-01-16 : 08:48:55 Hi I have defined a Remote Server with RPC in Security/Remote Servers inside SQL Server Enterprise. Is there some way to retrieve all databases and/or tables from that server? Something like "SELECT * FROM [myRemoteServer].[dbo].... Thanks