SQL Source Control (version 5.7) with default valuer missing

marcobranco

Hi.

I have this error:



After analyzing the error in CarMaker.sql, in the create table the default value is missing:

CREATE TABLE [dbo].[CarMaker]
(
[Id] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF_CarMaker_Id] DEFAULT -- No text is available,
[Name] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL,
(...)

I went to degin, and i have Default value newguid()

if i change the sql to

[Id] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF_CarMaker_Id] DEFAULT (newid()),-- No text is available,

i solve my problem, but a have almost 60 projects (Data Bases) with a lot of tables, and at this moment 75% of databases have this error.

Any options?

Also i use Sql Server 2008.

Thank's in advance

Marco Branco

RichardL

Hi @marcobranco

Thanks for your post. 

If you have a support contract then could you please send us a ticket so that a SQL Source Control specialist can have a look in to this for you? 

Kind regards

Richard Lynch.