rocky_498 (1/8/2013)
Could be Server Issue?
No
or still deadlock in que?
No.
Deadlocks occur when 2 pieces of code want the resources that the other is using. It's not a problem of one piece of code, rather of 2 (or more). If this proc is deadlocking on one server and not on the other, then the other server probably isn't running the code that this proc is deadlocking with.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability