Partition a table (two partitions) by date.
The original function is:
CREATE PARTITION SCHEME [EsquemaParticion2] AS PARTITION [FuncionParticion]
TO ([Historico1], [PRIMARY])
I need to modify this partition by adding a new partition, and modify the schema.
ALTER PARTITION SCHEME EsquemaParticion
NEXT USED Historico2;
Now I want to modify the function
ALTER PARTITION FUNCTION FuncionParticion() SPLIT RANGE (N'2016-01-
01T00:00:00')
I get this error:
Msg 15151, Level 16, State 1, Line 3
Cannot alter the partition function 'FuncionParticion', because it does not exist or you do not have permission.
The function already verifies and if it exists. I am working with the user sa
From Microsoft SQL Server Management Studio disables me the option of ALTER PARTITION FUNCTION
