United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

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 2012

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)

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.