|
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
Navigation:
[Reply to this message]
|