United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

Windows Server 2003

Protocol Reference Archive

Transact-SQL Reference (Transact-SQL)

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)

Windows Server 2003

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.

|

Site Feedback

© 2013 Microsoft. All rights reserved.