Technical Blog: Useful Stored Procedures for Linked Servers

Thursday, 21 February 2013

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

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)