Partitiong Functions
Without any changes on the database, SQL Source Control creates a tracked changed alternating between these two partitioning functions:
CREATE PARTITION FUNCTION [TranDate] ([datetime2] (0))
AS RANGE LEFT
FOR VALUES (N'2007-01-01 00:00:00', N'2008-01-01 00:00:00', N'2009-01-01 00:00:00', N'2010-01-01 00:00:00', N'2011-01-01 00:00:00', N'2012-01-01 00:00:00', N'2013-01-01 00:00:00', N'2014-01-01 00:00:00', N'2015-01-01 00:00:00')
and
CREATE PARTITION FUNCTION [TranDate] ([datetime2])
AS RANGE LEFT
FOR VALUES (N'2007-01-01 00:00:00', N'2008-01-01 00:00:00', N'2009-01-01 00:00:00', N'2010-01-01 00:00:00', N'2011-01-01 00:00:00', N'2012-01-01 00:00:00', N'2013-01-01 00:00:00', N'2014-01-01 00:00:00', N'2015-01-01 00:00:00')
Could something be done about it?
-
Ben Sala commented
I have a lot of tables partitioned on DATETIME2(2) data type, and have this same problem.