Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Sunny Florida
    Posts
    121

    Unanswered: exceed the limit of 256 tables. (not what you think)

    Yes, I do know what this means and why the error is thrown but this is not my question.

    I have two servers that are both running Windows Server 2003 and SQL Server 200 SP3. Below are the results from both servers using @@version

    Sever 1 (BB)

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05
    Copyright (c) 1988-2003 Microsoft Corporation
    Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    Server 2 (Genesis)

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05
    Copyright (c) 1988-2003 Microsoft Corporation
    Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    These servers are identical or so it seems. I've got a real ugly query that uses views and a derived table to get results. The problem is the 256 limit message only comes up on one server and on the other (Genesis) the query runs fine. I get the error though it reads a 260 limit on a box with SP4 applied. I've also run the query on a box that is Windows 2003, sql2k and sp4 and the query runs but not on a similar server here. This is all very odd. Please note that the database structure, views, etc are all exactly the same as far as I know.

    Any suggestions? There seems to be no pattern between versions of Windows and/or SP levels.
    Last edited by DBA-ONE; 02-22-07 at 14:44.

  2. #2
    Join Date
    Dec 2002
    Location
    Sunny Florida
    Posts
    121
    To the top

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •