-- Create Sample Partitioned Table
CREATE TABLE OrderEvents (
OrderCloseDate datetime not null,
OrderNum int not null,
[Status] char(2) null,
StatusDate datetime not null)
ON ps_FACT_DATA_DATE (MyDate)
Msg 1911, Level 16, State 1, Line 2
Column name 'MyDate' does not exist in the target table or view.
Should the MyDate in the partitionscheme call be OrderCloseDate? or is the partitiondb.sql script including missing something else? I get an error running this portion of the script and figured it was because this column isn't part of the table so it can't partition on it.
Thanks for looking,