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_copymergesnapshot(nvarchar @publication, nvarchar @destination_folder)
MetaData:
create procedure sys.sp_copymergesnapshot (
@publication sysname,
@destination_folder nvarchar(255)
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @retcode int
DECLARE @source_folder nvarchar(255)
SELECT @retcode = 0
EXEC @retcode = dbo.sp_MSreplcheck_publish
IF @@ERROR <> 0 or @retcode <> 0
return (1)
CREATE TABLE #snapshot_folders
(
id int identity,
snapshot_folder nvarchar(255) collate database_default
)
IF @@ERROR <> 0
BEGIN
RETURN 1
END
INSERT INTO #snapshot_folders
EXEC @retcode = sys.sp_browsemergesnapshotfolder @publication = @publication
IF @retcode <> 0 OR @@ERROR <> 0
BEGIN
GOTO Failure
END
SELECT @source_folder = (select top 1 snapshot_folder FROM #snapshot_folders ORDER BY id ASC)
IF @@ERROR <> 0
BEGIN
GOTO Failure
END
SET ROWCOUNT 0
EXEC @retcode = sys.sp_MScopysnapshot @source_folder,
@destination_folder
IF @retcode <> 0 OR @@ERROR <> 0
BEGIN
GOTO Failure
END
DROP TABLE #snapshot_folders
RETURN 0
Failure:
SET ROWCOUNT 0
DROP TABLE #snapshot_folders
RETURN 1
END
No comments:
Post a Comment