• That's a .Net error message, it's your client app that's run out of memory, not the server, not SQL.

    Most likely the plan is complex and the client is low on memory and trying to display the plan is making SSMS run out of memory. Try catching the plan via Profiler/server-side trace.

    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