Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

sp_catalogs (Transact-SQL)

SQL Server 2005

Returns the list of catalogs in the specified linked server. This is equivalent to databases in SQL Server 2005.

Topic link icon Transact-SQL Syntax Conventions

Copy 

sp_catalogs [ @server_name = ] 'linked_svr'
[ @server_name =] 'linked_svr'

Is the name of a linked server. linked_svr is sysname, with no default.

Column name Data type Description

Catalog_name

nvarchar(128)

Name of the catalog

Description

nvarchar(4000)

Description of the catalog

Requires SELECT permission on the schema.

The following example returns catalog information for the linked server named OLE DB ODBC Linked Server #3.

ms189764.note(en-US,SQL.90).gifNote:
For sp_catalogs to provide useful information, the OLE DB ODBC Linked Server #3 must already exist.

Copy 
USE master
GO
EXEC sp_catalogs 'OLE DB ODBC Linked Server #3'
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.