Competition: What’s your favorite Redgate tool? Enter now.

Sparse keyword breaking source control

jl45jl45 Posts: 10
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

Comments

  • 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>
Sign In or Register to comment.