I was uncertain about the locking going on during a Begin Trans --- commit, but I will try that. I can not revoke rights since our vendor has everyone as database owner. (yea I hate that) After you log into their app..it checks using the windows user ID.