• Is there something else other than a select statement in that proc? Trying to gauge if nolock is used in the proc at all.

    And back to Jacks question about isolation levels. Is the proc setting an isolation level within it? What is the isolation level set at for the database(s) in question?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events