When using SQL Enterprise Mangler 2000 you can expand the linked
servers to see views and tables.  I am having trouble getting this
functionality to work on 2005 Microsoft SQL Server Manglement
Studio....any successes out there?

As far as I know, this functionality was not implemented (unless it's hidden
somewhere I could not find it).  I think they felt it more important to
build a broken query designer and reproduce all of the inherently bad
features in Enterprise Manager than to port over any of the marginally
useful ones.  :-)

The thing I didn't like about this feature in 2000 is that it only showed me
the tables and views from the default database for the user set up as the
linked server authentication account -- this was not useful to me for two
reasons, one is that I would like to see more than just a list of tables and
views, I am typically looking to call stored procedures, and the other is
that I am typically interested in more than a single database on a server
(we don't have too many instances of SQL Server where there is only one
database or where there is only one database of interest).

Personally, I would rather see exactly what I see for a local server in the
registered server window... access to the full hierarchy of databases and
objects in the server.  But maybe that's just me.  I got around this by
simply not using the linked server node and instead registering the linked
server and accessing its objects that way.

Anyway, if you don't feel like registering the server for some reason (which
like I said would give you a lot more than a read-only list of the tables
and views), it's not too much effort to type the following:

SELECT name FROM linked_server_name.database_name.sys.tables;



Show quoteHide quote

how to pass in a long string to stored procedure
Need Help With a Simple Query
Error converting data type varchar to numeric
Check int value
BEGIN WHILE EOF