Useful Stored Procedures for Linked Servers

sp_tables_ex
Parameters

• @table_server
• @table_name
• @table_schema
• @table_catalog
• @table_type

sp_columns_ex
Parameters

• @table_server
• @table_name
• @table_schema
• @table_catalogue
• @column_name

sp_help is also a very useful system stored procedure
Parameters

•  @objname