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