Distributed Queries Stored Procedures (Transact-SQL)

SQL Server Developer Center

Troubleshooting

Printer Friendly Version

Send

MSDN Library

Servers and Enterprise Development

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-...

Distributed Queries Stored Procedur...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (3)

Click here to expand

Collapse All/Expand All

SQL Server 2005 Books Online (November 2008)

Distributed Queries Stored Procedures (Transact-SQL)

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

See Also

Reference

System Stored Procedures (Transact-SQL)

Other Resources

Distributed Queries

Help and Information

Getting SQL Server 2005 Assistance

Tags

What's this?

: Add a tag

Community Content

What is Community Content?

Add new content

Annotations

Processing

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement