• ravisamigo (11/22/2010)


    Thanks, But it would be better to set max worker threads to 288 as per the below link and also default setting for SQLServer2005 is 0.

    Since this question is posted under SQL 2000 forum, I had given the URL for SQL Server 2000.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga