SQL Server Performance Forum – Threads Archive

table partition

CREATE PARTITION FUNCTION myRangePF1 (int)
AS RANGE LEFT FOR VALUES (1, 100, 1000) ;
GO
CREATE PARTITION SCHEME myRangePS1
AS PARTITION myRangePF1
TO (test1fg, test2fg, test3fg, test4fg) ;
GO
CREATE TABLE PartitionTable (col1 int, col2 char(10))
ON myRangePS1 (col1) ;
GO
Above is the script for doing the table partition.
But I wander wheather the wizard for doing the partition is avaialbe for create the above procedure.
Has anybody know where is the wizard at the Ms sql 2005 for creating the table partiotion purpose.
Thanks.

---

AFAIK not.
Maybehttp://www.sqlskills.com/resources/Whitepapers/Partitioning in SQL Server 2005 Beta II.htm clarifies a bit.

---

I haven’t came across such a option —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

]]>