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