Hi, I have a weird T-SQL 80 query full of nested subqueries full of aggregations tha thas been embedded in a view.
if I do select * from the view I get: Server: Msg 8624, Level 16, State 13 Internal SQL Error.
If I run the same block of code from the query analyzer it runs fine. Also if I wrap exactly the same code in a SP it runs fine.
I'm running this on a SQL Server 2000 Standard Edition SP4 8.00.2282. + I turned on the following Trace Flags: 3614, 9052, 9054, 9056, 9057, 9185, 9256.
If I restore the same DB on a SQL Server 2005 and do the same select * it runs fine. So I'm getting the Error 8624 only on my SQL 2000 Standard edition SP4 8.00.2282.
Another thing I dont understand is also: why I can compile the view but if I try to visualize even the query plan I get the same error?!?
Any suggestion will be appreciated. Thank you.
View Complete Post