spTransactions_InsertSignup

            CREATE procedure [dbo].[spTransactions_InsertSignup]
                (
                @ClientsID int,
                @xmlData ntext,
                @UserID int = NULL,
                @EmailJobRecipientID int,
                  @SimpleEmailSignup int = NULL
                )

                AS
                BEGIN

                if datalength(@xmlData)<8 begin
                   RAISERROR ('Unable to insert transaction - SignupTransactions.XMLObjectData cannot be a zero-length string and must be well formed XML',16,1)
                   return 0
                end

                BEGIN TRAN

                if @EmailJobRecipientID <= 0 set @EmailJobRecipientID = NULL

                insert into dbo.SignupTransactions
                (ClientsID,XMLObjectData,UserID,[EmailJobRecipientID],SimpleEmailSignup) 
                values
                (@ClientsID,@xmlData,@UserID,@EmailJobRecipientID,@SimpleEmailSignup)


                --This will save the transaction into the BBNCTransactions Table
                Declare @BBNCTransactionsPKID int
                Set @BBNCTransactionsPKID = 0

                Declare @TransactionPKID int
                Set @TransactionPKID = SCOPE_IDENTITY()

                Declare @TransactionType nvarchar(100)
                Set @TransactionType = '{5F84002B-ABB1-4f50-A244-D4B14FBB1579}'

                exec spTransactions_InsertTransaction @BBNCTransactionsPKID, @TransactionPKID, @TransactionType, @xmlData, @UserID, 0

                if @@error = 0
                begin
                    commit tran
                    return @TransactionPKID
                end
                else
                begin
                    rollback tran
                    return 0
                end

                END