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_oledbinfo(nvarchar @server, nvarchar @infotype
, nvarchar @login
, nvarchar @password)
MetaData:
create procedure sys.sp_oledbinfo
@server nvarchar(128),
@infotype nvarchar(128) = NULL,
@login nvarchar(128) = NULL,
@password nvarchar(128) = NULL
AS
SET NOCOUNT ON
DECLARE @distributor sysname
DECLARE @distproc nvarchar (255)
DECLARE @retcode int
--
-- Security Check: require sysadmin
--
IF (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 0)
BEGIN
RAISERROR(21089,16,-1)
RETURN (1)
END
--
-- Get distribution server information for remote RPC
-- subscription calls.
--
EXEC @retcode = sys.sp_MSrepl_getdistributorinfo @rpcsrvname = @distributor OUTPUT
IF @@error <> 0 OR @retcode <> 0
BEGIN
RAISERROR (14071, 16, -1)
RETURN (1)
END
select @distproc = QUOTENAME(rtrim(@distributor)) + '.master.sys.sp_MSget_oledbinfo'
exec @retcode = @distproc @server, @infotype, @login, @password
IF @@error <> 0
BEGIN
RAISERROR (14071, 16, -1)
RETURN (1)
END
No comments:
Post a Comment