question

venkatreddy avatar image
venkatreddy asked

syntax error while creating partition function

im creating partition function as,

CREATE PARTITION FUNCTION cct_part_emid(INT) 
AS RANGE LEFT FOR VALUES(10000,50000)

im getting error while executing the above query as 

Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'PARTITION'.

anything wrong with my syntax? im working with SQL server developer edition(8.00.194)

t-sqlpartitioning
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

That's SQL Server 2000. It doesn't support partitioning. You'll need to get a newer version of SQL Server. I'd recommend SQL Server 2008. Partitioning started in SQL Server 2005, but 2008 added some great functionality.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.