How can we help you today? How can we help you today?

Sparse keyword breaking source control

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
0

Comments

1 comment

Sort by
  • 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>
    jl45
    0

Add comment

Please sign in to leave a comment.