I was able to find an equivalant for

select *

from master.dbo.SYSREMOTE_TABLES (

'lnkservername',

...

Yes, i tried the query

select *

from master.dbo.SYSREMOTE_TABLES (

'LnkServerName',

...

Hi,

is there an equivalent query for SQL 2005?

Thank you very much for the quick response.

That provided the data that i wanted. I kicking myself for forgetting about using OPENQUERY to retrieve the information.

I...

thanks for the reply; not all the servers are SQL servers. I have an informix, and MySQL server. What i am trying to do is create a user...

I gave that a try but i received the following error invalid object name linksername.dbname.sysobjects