This blog is mostly a blog for me with hints to remember those little bits of code etc where ever I am. Please be aware of this when reading any of the posts as they are mainly reminders for me. When I get time I will try to flesh out those sections that are a little ambiguous.
Pages
▼
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
No comments:
Post a Comment
Note: only a member of this blog may post a comment.