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