United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

Distributed Queries Stored Procedures (Transact-SQL)

sp_addlinkedserver (Transact-SQL)

sp_addlinkedsrvlogin (Transact-SQL)

sp_catalogs (Transact-SQL)

sp_column_privileges_ex (Transact-SQL)

sp_columns_ex (Transact-SQL)

sp_droplinkedsrvlogin (Transact-SQL)

sp_foreignkeys (Transact-SQL)

sp_indexes (Transact-SQL)

sp_linkedservers (Transact-SQL)

sp_primarykeys (Transact-SQL)

sp_serveroption (Transact-SQL)

sp_table_privileges_ex (Transact-SQL)

sp_tables_ex (Transact-SQL)

sp_testlinkedserver (Transact-SQL)

Minimize

0 out of 1 rated this helpful - Rate this topic

Distributed Queries Stored Procedures (Transact-SQL)

SQL Server 2008 R2

SQL Server supports the following system stored procedures that are used to implement and manage Distributed Queries.

sp_addlinkedserver	sp_indexes
sp_addlinkedsrvlogin	sp_linkedservers
sp_catalogs	sp_primarykeys
sp_column_privileges_ex	sp_serveroption
sp_columns_ex	sp_table_privileges_ex
sp_droplinkedsrvlogin	sp_tables_ex
sp_dropserver (Transact-SQL)	sp_testlinkedserver (Transact-SQL)
sp_foreignkeys

Reference

System Stored Procedures (Transact-SQL)

Concepts

Distributed Queries

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.