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_gettype_mappings(nvarchar @dbms_name, nvarchar @dbms_version
, nvarchar @sql_type
, int @source_prec)
MetaData:
create procedure sys.sp_MSrepl_gettype_mappings
(
@dbms_name sysname,
@dbms_version sysname = NULL,
@sql_type sysname = '%',
@source_prec int = NULL
)
as
set nocount on
declare @retcode int
declare @distributor sysname
declare @distribdb sysname
declare @distproc nvarchar (255)
EXECUTE @retcode = sys.sp_MSrepl_getdistributorinfo @rpcsrvname = @distributor OUTPUT,
@distribdb = @distribdb OUTPUT
IF @@ERROR <> 0 or @retcode <> 0
BEGIN
RAISERROR (14071, 16, -1)
RETURN (1)
END
SELECT @distproc = QUOTENAME(RTRIM(@distributor)) + '.' + QUOTENAME(RTRIM(@distribdb)) + '.sys.sp_help_datatype_mapping'
EXECUTE @retcode = @distproc
@dbms_name = @dbms_name,
@dbms_version = @dbms_version,
@sql_type = @sql_type,
@source_prec = @source_prec
IF @@ERROR <> 0 OR @retcode <> 0
return 1
ELSE
return 0
No comments:
Post a Comment