[ @server_name =] 'linked_svr'

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

Requires SELECT permission on the schema.

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'

Reference

Help and Information