stored procedure changed to be transactional