Post reply

SQL 2000 View error

  • July 14, 2003 at 10:25 pm

    #159542

    Hi All

    I have a view that was working ok in SQL 7 but is not working in SQL 2000. The error I get when selecting the view is as follows:

    Server: Msg 4414, Level 16, State 1, Line 1

    Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (256) was exceeded.

    The view is quite complex and has about six UNIONs. If I comment out some of the UNIONs the view can be selected ok.

    The view does actually build ok.

    Thanks

    marceloL

  • July 15, 2003 at 7:13 am

    #465538

    You need to get the latest Service Pack. This error was corrected in Service Pack 2 (refer to Q308744).

    All the best,

    Dale


    All the best,

    Dale

    Author: An Introduction to SQL Server 2005 Management Studio

  • July 15, 2003 at 5:01 pm

    #465611

    Dale

    Thanks for your reply. I thought that this was the case but I wasn't 100% sure.

    The thing is though that we are on SP3. I didn't build the server myself so I think I may need to ask some questions.

    Thanks one again

    marceloL

    quote:

    You need to get the latest Service Pack. This error was corrected in Service Pack 2 (refer to Q308744).

    All the best,

    Dale

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply