Hi Guys,
I have 2 environments i work on , one is SQL server 2005 enterprise
edition and the other is developer edition (both with Service Pack).
i have a scripts creating a partition table who runs well on the
Enterprise version but when i run it over the Development server it
does nothing (it doesn't fail and no warnings are thrown but the
resulting table is not partitioned).
anyone has a clue '
according to Microsoft developer edition should support partition
tables .
below is the code relevant :
-- drop partition schema
-- drop partition function
-- create partition function
-- create partition schema
CREATE TABLE [dbo].[Fact_DaySales22](
[Day_Key] [int] NOT NULL,
[DW_Store_Key] [smallint] NOT NULL,
[DW_Item_Key] [int] NOT NULL,
[DW_Supplier_Key] [int] NOT NULL,
[MatrixMemberId] [smallint] NOT NULL,
[Sales] [decimal](13, 2) NULL,
[Discount] [decimal](13, 3) NULL,
[Qty] [int] NULL,
[WeightedQty] [decimal](9, 3) NULL,
[Tax] [decimal](9, 3) NULL,
[Cost] [decimal](13, 3) NULL
CONSTRAINT [PK_Fact_DaySales22] PRIMARY KEY NONCLUSTERED
(
[MatrixMemberId] ASC,
[Day_Key] ASC,
[DW_Store_Key] ASC,
[DW_Item_Key] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [MonthlyDataPScheme22]([Day_Key])
) ON [MonthlyDataPScheme22]([Day_Key])Have the filegroups been created on the development server? Are the
appropriate partitioning function and the partitioning schema in place?
These things are not evident from your post.
ML
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/
No comments:
Post a Comment