• That's the output from1204, which is very limited and very hard to interpret. 1204 should only be used on SQL 2000 where it's the only option. 1222 produces much better output on SQL 2005+

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass