May 25, 2012

sp_MSrepl_linkedservers_rowset (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_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

Total Pageviews