syntax error while creating partition function

Question

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)

Answer 1

0

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.

answered Mar 18 '10 at 02:47 PM

Grant Fritchey ♦♦
62.3k ● 12 ● 20 ● 66

(comments are locked)

syntax error while creating partition function

Follow this question

Related Questions