TRUNCATE TABLE WITH (PARTITIONS()) breaks SSC

strvmarv · February 20, 2017 4:44PM

Every single time I check-in a stored procedure with the usage of TRUNCATE TABLE and WITH (PARTITIONS()) the commit occurs just fine, but SSC breaks permanently on a parsing error. The only way to resolve is to delete the sproc and re-link the DB. Example below, which works just fine in SSMS and Azure SQL when created and executed. This has been happening for some time. What am I supposed to do?

Error:

Errors occurred whilst parsing file (sproc path and filename here)
'' at line 10, column 7

CREATE PROCEDURE &#91;dbo&#93;.&#91;sproc_TruncateWithPartitions_Example&#93;
	@row int
WITH EXECUTE AS OWNER 
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	--DECLARE @row int = 17

    TRUNCATE TABLE &#91;dbo&#93;.&#91;ClientLogStaging&#93; WITH (PARTITIONS (@row))

END

Sergio R · February 21, 2017 2:48PM

Hi,

This feature is still not supported in SQL Source Control.
Please follow this thread for updates on this.

Thank you,

Sergio R · April 4, 2017 7:20AM

This now works in the latest version of SQL Source Control available in the Frequent Releases channel, version 5.5.4

TRUNCATE TABLE WITH (PARTITIONS()) breaks SSC

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk