USP_SECUREGATEWAY_CREDENTIALS_DELETE

        create procedure dbo.USP_SECUREGATEWAY_CREDENTIALS_DELETE(
                @ID uniqueidentifier
        )
        as
        begin

            declare @CHANGEAGENTID uniqueidentifier;
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            -- use the system generated delete routine to allow proper recording of the deleting agent

            exec USP_SECUREGATEWAYCREDENTIALS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
        end