Posted by Razvan Socol on 12/17/05 19:17

> I understand from Books Online that a partioned view
> requires a partioned table???
> This client is using SQL Server 2000

No, a "partitioned view" and a "partitioned table" are different
things. "Partitioned table"-s work only in SQL Server 2005. If you use
SQL Server 2000, you can use a partitioned view. See:
http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_06_17zr.asp

> Unfortunately, the client architecture rules require
> the data to reside in approx 250 different tables.

For what purpose ? Performance ? Security ? You should evaluate if the
original reason (for this architecture) is still accomplished best in
this way or if there are another ways to do it.

Razvan

[Back to original message]