April 21, 2009 at 4:27 pm
At long last I've gotten my IT department to set up a link to a remote server. Sure would be nice to be able to view the list of tables on the remote server! The only way I've found to do this so far is by using a system stored procedure:
:
sp_tables_ex
@table_server = 'DTMFLKSVDB03',
@table_catalog='FnetIntranet',
@table_schema='dbo'
How can I set up a VIEW to return this same information? Or is there a better way?
__________________
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
April 21, 2009 at 5:03 pm
This is really going to depend upon the server that you are linked to. If that server is SQL Server 2005 or 2008, you could use the following:
SELECT {columns}
FROM linked_server.database.sys.tables;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 21, 2009 at 5:40 pm
Thanks, just what I was looking for!
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply