USE [NETMDM_SAMPLE]
GO
 
CREATE PARTITION FUNCTION netmdm_monitoring_security_pf (datetime)
AS RANGE RIGHT FOR VALUES (
 '20110101','20110102','20110103','20110104','20110105','20110106'
,'20110107','20110108','20110109','20110110','20110111','20110112'
,'20110113','20110114','20110115','20110116','20110117','20110118'
,'20110119','20110120','20110121','20110122','20110123','20110124'
,'20110125','20110126','20110127','20110128','20110129','20110130'
,'20110131'
,'20110201','20110202','20110203','20110204','20110205','20110206'
,'20110207','20110208','20110209','20110210','20110211','20110212'
,'20110213','20110214','20110215','20110216','20110217','20110218'
,'20110219','20110220','20110221','20110222','20110223','20110224'
,'20110225','20110226','20110227','20110228'
,'20110301','20110302','20110303','20110304','20110305','20110306'
,'20110307','20110308','20110309','20110310','20110311','20110312'
,'20110313','20110314','20110315','20110316','20110317','20110318'
,'20110319','20110320','20110321','20110322','20110323','20110324'
,'20110325','20110326','20110327','20110328','20110329','20110330'
,'20110331'
,'20110401','20110402','20110403','20110404','20110405','20110406'
,'20110407','20110408','20110409','20110410','20110411','20110412'
,'20110413','20110414','20110415','20110416','20110417','20110418'
,'20110419','20110420','20110421','20110422','20110423','20110424'
,'20110425','20110426','20110427','20110428','20110429','20110430'
,'20110501','20110502','20110503','20110504','20110505','20110506'
,'20110507','20110508','20110509','20110510','20110511','20110512'
,'20110513','20110514','20110515','20110516','20110517','20110518'
,'20110519','20110520','20110521','20110522','20110523','20110524'
,'20110525','20110526','20110527','20110528','20110529','20110530'
,'20110531'
,'20110601','20110602','20110603','20110604','20110605','20110606'
,'20110607','20110608','20110609','20110610','20110611','20110612'
,'20110613','20110614','20110615','20110616','20110617','20110618'
,'20110619','20110620','20110621','20110622','20110623','20110624'
,'20110625','20110626','20110627','20110628','20110629','20110630'
)
GO
CREATE PARTITION SCHEME netmdm_monitoring_security_ps AS PARTITION
netmdm_monitoring_security_pf TO (
 [netmdm_moni_seg]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001],[netmdm_moni_dp_0001],[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0001]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002],[netmdm_moni_dp_0002],[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0002]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003],[netmdm_moni_dp_0003],[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0003]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0004],[netmdm_moni_dp_0004],[netmdm_moni_dp_0004]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005],[netmdm_moni_dp_0005],[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0005]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
,[netmdm_moni_dp_0006],[netmdm_moni_dp_0006],[netmdm_moni_dp_0006]
)
GO