April 16, 2012

sp_catalogs_rowset_rmt (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_catalogs_rowset_rmt(nvarchar @server_name
, nvarchar @catalog_name)

MetaData:

   
create procedure sys.sp_catalogs_rowset_rmt
(
@server_name sysname,
@catalog_name sysname = NULL
)
as
select
CATALOG_NAME,
DESCRIPTION
from
sys.fn_remote_catalogs (@server_name, @catalog_name)
where
has_dbaccess(CATALOG_NAME)=1
order by 1

No comments:

Post a Comment

Total Pageviews