Table partitioning

• vish-531091

  Right there with Babe

  Points: 738

  More actions

  July 14, 2008 at 10:32 pm

  #124680

  Hi,

  Could anyone tell me how to achieve a HORIZONTAL TABLE PARTIONING in sql 2000.. i guess it is made simpler in SQL 2005

  through PARTION function, filegroups etc..

  but i couldnt get clearly how to do it in SQL 2000.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  July 15, 2008 at 11:09 am

  #843263

  Please check Partitioned View in books online.

  Hope this is what you asked for...

  Manu

• umailedit

  SSCrazy

  Points: 2087

  More actions

  July 16, 2008 at 7:48 am

  #843768

  Partitioning is available only for SQL 2005 and above. Also only a maximum of 1000 partitions can be made on a table.

• Jacob Luebbers

  SSCarpal Tunnel

  Points: 4834

  More actions

  July 17, 2008 at 5:42 pm

  #844729

  umailedit (7/16/2008)

  ---

  Partitioning is available only for SQL 2005 and above...

  I'm afraid that's incorrect. Partitioned views are available on SQL Server 2000 - see here for more info: http://msdn.microsoft.com/en-us/library/aa933141(SQL.80).aspx

  Regards,

  Jacob