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

SQL Source Control (version 5.7) with default valuer missing

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



marcobranco
0

Comments

1 comment

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

Add comment

Please sign in to leave a comment.