Phill,

Did you state that you have run the code under debug and no statements, except the create procedure, got run ?

I see the other scenary.

When I run the code in debug...

Thank you for reply. The sample code is below. But I think the problem is not the code but the server/database status. The same piece of code run on a different...