• So in that case would you say that the schema locks are being caused by something else? I.e. an alter table or something like that?

    Also can you clarify which way round this is as well. The wait type is schema lock. Does this mean that the sp is waiting to get a schema lock so that it can modify schema or is it that something else has a schema lock and it is waiting on that other request to lift the schema lock before it can continue?