• Wow, this is an old thread..

    I do have a question though. In SQL 2005, can a value be passed to OPTION (MAXDOP n) with out creating dynamic sql code?

    EX: OPTION (MAXDOP @maxdopvalue)