March 6, 2003 at 8:28 am
Is there a way to "SEE" the tables and info contained on a remote shared MS SQL server, such as table name size etc ???
Other than having to have Enterprise Manager ??
Any help would really be appreciated.
Thanks
Julian
March 6, 2003 at 9:01 am
You can query the system tables directly, or use the information schema views, either from Query Analyzer (or use ADO/ADO.Net to run the query will work too).
Andy
March 6, 2003 at 9:38 am
Try sp_tables_ex, sp_columns_ex, sp_primarykeys if the remote SQL Server has been configured as linked server.
March 6, 2003 at 10:04 am
Of course, there's always SQL-DMO. You could always "build" your own EM using it. It really depends on what you want to do with it.
March 6, 2003 at 10:26 am
sp_helpdb, etc. There are numerous stored procedures the produce the information you seein Enterprise Manager.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply