The table in question does not fall within any of those restrictions. Thanks for the feedback!

JoshDBGuy,

The solution of checking for a lock is precisely where I was today, also I will be changing the design of this staging area. Planning to move it off...

Nothing that involved or complicated is happening with this proc, it is as simple as simple gets. I did make use of a Try/Catch block, sending error data to a...

And your server is a production server? have you noticed any degradation in performance during peek times? How long have you been using your virtualized SQL server?

Thanks for the feedback!

//Carlos