Partitioned View Problem

dUkE!


Hi all,

I am designing 3 p:artitioned views for 3 tables. Those tables grow up in 1.5 millions of rows per month (each one), so I decided to partition those tables monthly. The issue is that if I want to create the views with more than 256 months (256 tables) SQL Server says: 'Server: Msg 106, Level 15, State 1, Procedure Jugadas, Line 258
Too many table names in the query. The maximum allowable is 256.'

Is there any workaround for this

Another solution maybe

PD1: I've tested with less than 256 tables and it works fine, I can update and query the tables (except for a couple of querys where I've got to join 2 or more of the involucred views in which case I got a similar error saying about a 260 table limit).

asiaindian

Hello,

I am assuming you are using SQL 2000. In SQL 2000, the partitions you have created are actually physical tables. You must be creating a view using these physical tables. In a SQL query you cannot use more than 256 tables. The link below might help....

http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx

If you are using SQL 2005, then it would make your life easy. SQL 2005 allows 1000 partitions in a table.

Hope this helped...

Regards....

dUkE!

Thanks for your reply.

Yes I'm using SQLServer 2000.....

..... still no hope