USP_GLOBALCHANGE_RIGHTTOBEFORGOTTEN
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @ASOF | datetime | IN | |
| @NUMBERADDED | int | INOUT | |
| @NUMBEREDITED | int | INOUT | |
| @NUMBERDELETED | int | INOUT | |
| @IDSETREGISTERID | uniqueidentifier | IN | |
| @PURGEACTIVE | bit | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_GLOBALCHANGE_RIGHTTOBEFORGOTTEN
(
@CHANGEAGENTID uniqueidentifier = null,
@ASOF as datetime = null,
@NUMBERADDED int = 0 output,
@NUMBEREDITED int = 0 output,
@NUMBERDELETED int = 0 output,
@IDSETREGISTERID uniqueidentifier,
@PURGEACTIVE bit,
@CURRENTAPPUSERID uniqueidentifier
)
as
set nocount off;
exec USP_GLOBALCHANGE_RIGHTTOBEFORGOTTEN_REMOVEAUDITDATA @CHANGEAGENTID,@ASOF,@NUMBERADDED OUTPUT,@NUMBEREDITED OUTPUT,@NUMBERDELETED OUTPUT,@IDSETREGISTERID,@PURGEACTIVE,@CURRENTAPPUSERID;