GilaMonster (11/24/2015)

---

Create Partition Scheme Yearly_Date_Range_ps

As PartitionYearly_Date_Range_pf

All To ([Primary]);

Go

You're missing a space. The partition function is named Yearly_Date_Range_pf, and you left out the space between the PARTITION keyword and the name of the partition function.

A quick look at https://msdn.microsoft.com/en-us/library/ms179854.aspx, comparing their examples would have shown you that.