USP_MERGECONFIGURATION_CREATEPROCEDURE
This procedure is used to create a merge procedure that is associated with a merge configuration.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONFIGNAME | nvarchar(100) | IN | |
| @PROCBODY | nvarchar(max) | IN |
Definition
Copy
CREATE procedure dbo.USP_MERGECONFIGURATION_CREATEPROCEDURE
(
@CONFIGNAME nvarchar(100),
@PROCBODY nvarchar(max)
)
with execute as owner
as
set nocount on;
exec ('if exists (select * from sys.objects where object_id = OBJECT_ID(N''[dbo].[USP_MERGEPROC_' + @CONFIGNAME + ']'') and type in (N''P'', N''PC'')) drop procedure [dbo].[USP_MERGEPROC_' + @CONFIGNAME + ']');
exec ('create procedure dbo.[USP_MERGEPROC_' + @CONFIGNAME + '] (@TARGET uniqueidentifier, @SOURCE uniqueidentifier, @CHANGEAGENT uniqueidentifier, @MANUALMERGE bit = 0) as ' + @PROCBODY);
exec ('grant execute on dbo.[USP_MERGEPROC_' + @CONFIGNAME + '] to BBAPPFXSERVICEROLE');
return 0;