- You have a partitioned table that uses a datetimeoffset type column as a partitioning column in Microsoft SQL Server 2008 R2.
- You use the New Publication Wizard to create a snapshot publication of the partitioned table in SQL Server Management Studio (SSMS).
Incorrect syntax near ''.
Note For a detailed example scenario in which this issue would occur, refer to the "More Information" section.
Cumulative update information
Cumulative Update 5 for SQL Server 2008 R2 SP2The fix for this issue was first released in Cumulative Update 5. For more information about how to obtain this cumulative update package for SQL Server 2008 R2 SP 2, click the following article number to view the article in the Microsoft Knowledge Base:
For example, you execute the following statement to create a partition function:
CREATE PARTITION FUNCTION PF_TEST (datetimeoffset(7)) as range right for values('20100101', '20100201', '20100301')
If you try to run the generated script, then you receive the following error message:
Incorrect syntax near '12'.
Article ID: 2791626 - Last Review: Feb 18, 2013 - Revision: 1