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