1

Closed

Partition functions with a '.' in its name are not handled properly (and maybe so do the partition schemes).

description

You can create a partition function with CREATE PARTITION FUNCTION Person.PF_Address RANGE LEFT FOR VALUES (10000, 20000, 30000);
 
This function will not be handled properly due to the dot ('.') in the name. It should work if you quote the name of the partition function with '[' and ']'. Maybe the same error will rise with a partition scheme with a dot inside the name.
 
Workaround: Changing the name of the partition function (e.g. replace all '.' with '_').
Closed Nov 21, 2012 at 10:26 PM by Stuarto
I verified that this is not a problem with Partition Management Utility Version 2. Partition functions and schemes with "." characters are handled fine. If you have a continuing problem please send specific script with repro details.

comments