/****** Object:  Stored Procedure dbo.ujo_put_sendbuf    Script Date: 12/1/2005 11:49:51 PM ******/

create proc ujo_put_sendbuf
    @eoid        varchar(12),
    @serverdb    varchar(40)

AS


if exists ( select eoid from ujo_send_buffer
         where eoid = @eoid AND serverdb = @serverdb )
    return 1


insert ujo_send_buffer ( eoid, serverdb, stamp, send_status )
values ( @eoid, @serverdb, getdate(), 0 )

if @@rowcount = 1
    return 1

return -1
GO
GRANT EXECUTE ON  [dbo].[ujo_put_sendbuf] TO [ujoadmin]
GO