Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL Server 2005.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_catalogs [ @server_name = ] 'linked_svr'
Arguments
- [ @server_name =] 'linked_svr'
Is the name of a linked server. linked_svr is sysname, with no default.
Result Sets
| Column name | Data type | Description |
|---|---|---|
Catalog_name |
nvarchar(128) |
Name of the catalog |
Description |
nvarchar(4000) |
Description of the catalog |
Permissions
Requires SELECT permission on the schema.
Examples
The following example returns catalog information for the linked server named OLE DB ODBC Linked Server #3.
Note
For sp_catalogs to provide useful information, the OLE DB ODBC Linked Server #3 must already exist.
USE master
GO
EXEC sp_catalogs 'OLE DB ODBC Linked Server #3'
See Also
Reference
sp_addlinkedserver (Transact-SQL)
sp_columns_ex (Transact-SQL)
sp_column_privileges (Transact-SQL)
sp_foreignkeys (Transact-SQL)
sp_indexes (Transact-SQL)
sp_linkedservers (Transact-SQL)
sp_primarykeys (Transact-SQL)
sp_tables_ex (Transact-SQL)
sp_table_privileges (Transact-SQL)
System Stored Procedures (Transact-SQL)