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_MSuploadsupportabilitydata(nvarchar @publisher, nvarchar @publisher_db
, nvarchar @publication
, nvarchar @server_name
, nvarchar @db_name
, nvarchar @file_name
, int @log_file_type
, varbinary @log_file
, nvarchar @web_server
, int @compatlevel)
MetaData:
create procedure sys.sp_MSuploadsupportabilitydata (@publisher sysname, @publisher_db sysname, @publication sysname, @server_name sysname = NULL, -- Replica or subscriber Server Name -- @db_name sysname = NULL, -- Replica or subscriber Database Name -- @file_name nvarchar(2000), -- data for the log file -- @log_file_type int, @log_file varbinary(max) = NULL, -- data for the log file -- @web_server sysname = NULL, -- name of the IIS server -- @compatlevel int = 90) -- backward compatibility level, default=Sphinx as declare @retcode int declare @subid uniqueidentifier declare @pubid uniqueidentifier declare @upload_time datetime select @publisher_db = RTRIM(@publisher_db) select @db_name = RTRIM(@db_name) -- -- Security Check and publication validation -- exec @retcode = sys.sp_MSmerge_validate_publication_presence @publication, @publisher_db, @publisher, @pubid output if @retcode <> 0 or @@error <> 0 return 1 if (@server_name is NULL) SET @server_name = publishingservername() if (@db_name is NULL) set @db_name = db_name() SELECT @subid = subid FROM dbo.sysmergesubscriptions WHERE UPPER(subscriber_server) collate database_default = UPPER(@server_name) collate database_default and db_name = @db_name and pubid = @pubid if @subid is NULL begin RAISERROR(20021, 16, -1) return (1) end select @upload_time = getdate() -- Insert the log data into the MSmerge_log_files table insert into dbo.MSmerge_log_files (pubid, subid, web_server, file_name, upload_time, log_file_type, log_file) values (@pubid, @subid, @web_server, @file_name, @upload_time, @log_file_type, @log_file) if @@error <> 0 return 1 update dbo.MSmerge_supportability_settings set last_log_upload_time = @upload_time WHERE pubid = @pubid and subid = @subid and ((@web_server IS NULL and web_server IS NULL) or (@web_server IS NOT NULL and UPPER(web_server) collate database_default = UPPER(@web_server) collate database_default )) if @@error <> 0 return 1 return (0)
No comments:
Post a Comment