United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language 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

This topic has not yet been rated - Rate this topic

Distributed Queries Stored Procedures (Transact-SQL)

SQL Server 2005

SQL Server 2005 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)

Other Resources

Distributed Queries

Help and Information

Getting SQL Server 2005 Assistance

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.