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_MSrepl_linkedservers_rowset(nvarchar @srvname, int @agent_id
, int @agent_type)
MetaData:
create procedure sys.sp_MSrepl_linkedservers_rowset ( @srvname sysname, @agent_id int, @agent_type int = 0 -- 0: distagent 1: merge ) as begin declare @retcode int -- Security check: sysadmin/dbo/PAL only exec @retcode = sys.sp_MScheck_pull_access @agent_id = @agent_id, @agent_type = @agent_type if @@error <> 0 or @retcode <> 0 return 1 SELECT SVR_NAME = srvname, SVR_PRODUCT = srvproduct, SVR_PROVIDERNAME = providername, SVR_DATASOURCE = datasource, SVR_PROVIDERSTRING = providerstring, SVR_LOCATION = location, SVR_CATALOG = catalog FROM master.dbo.sysservers WHERE UPPER(srvname) = UPPER(@srvname) collate database_default AND ISNULL(providername,' ') <> ' ' AND ( ISNULL(datasource, ' ') <> ' ' or ISNULL(location, ' ') <> ' ' or ISNULL(providerstring, ' ') <> ' ' or ISNULL(catalog, ' ') <> ' ' ) ORDER BY 1 if @@error <> 0 return 1 else return 0 end
No comments:
Post a Comment