Home Forums SQL Server 7,2000 T-SQL Internal Query Processor Error: The query processor ran out of stack space during query optimization. RE: Internal Query Processor Error: The query processor ran out of stack space during query optimization.

  • Thanks Frank but the normalization is affected and under awareness. 

    I think the reason is the high FK’s number that references on that table.

    I found the below limitations for SQL Server 2000:

     

    Foreign key table references per table

    253

    REFERENCES per table

    253

    http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

    What do you think?? it's right??