Please take this for an example:

CREATE PARTITION FUNCTION [myPF1] (datetime)

AS RANGE LEFT FOR VALUES ('20110731', '20110807', '20110814', '20110821');

CREATE PARTITION SCHEME myPS2

AS PARTITION myPF1

TO ( fg1, fg2, fg3, fg4 );

This should...

Using SA and db_owner really makes the life easy but that power should be maintained by the dba, it will be a bit of a work but i will suggest...