May 25, 2012

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

Total Pageviews