Sparse keyword breaking source control

jl45

Can anyone help with a workaround?

The following proc breaks source control, if you remove the sparse keyword then it is fine

CREATE PROC [dbo].[sparse_test] 

AS


SELECT 'abc' AS id INTO dbo.abc

ALTER TABLE dbo.abc ALTER COLUMN id VARCHAR(100) SPARSE

DROP TABLE abc
GO

the error message I receive is:

Errors occurred whilst parsing file C:UserszzzAppDataLocalRed GateSQL Source Control 3WorkingBasesesgzatsf.wg3Stored Proceduresdbo.sparse_test.sql

'' at line 6, column 7

jl45

This has been acknoledged as a bug.

As a workaround you can right click the linked to url on the setup tab and select edit comparison options

and set the following option:

<ThrowOnFileParseFailed>False</ThrowOnFileParseFailed>