syntax error in the SQL script

• 
  Hello,
  
  That's interesting... what name do you get back when you run

  select name from sysobjects where name like 'DF_field_reporter_text_frt_lang_code 
  frt_lang_%' AND xtype='F'
  

  Brian Donahue August 17, 2006 12:30

  - 0 +
• 
  Nothing came back from
  

  select name from sysobjects where name like 'DF_field_reporter_text_frt_lang_code 
  frt_lang_%' AND xtype='F'
  

  
  but that made me dig deeper into our database, and that is where the problem was. :oops:
  
  
  When we generated the script for the destination table, we got

  CREATE TABLE [*****].[field_reporter_text]
  (
  [frt_fr_text_id] [int] NOT NULL IDENTITY(1, 1),
  [frc_category_id] [int] NULL,
  [frt_form_text] [text] NOT NULL,
  [frt_language] [varchar] (10) NULL,
  [frt_lang_code] [int] NOT NULL CONSTRAINT [DF_field_reporter_text_frt_lang_code
  frt_lang_code]] DEFAULT (17),
  [frt_effective_date] [datetime] NOT NULL,
  [frt_inactive_date] [datetime] NULL
  )
  
  GO
  

  showing the contraint definition was bad.
  
  Somehow, the contraint was not showing in the diagrams, or design wizards in Enterprise Manager. :shock: SQL Compare generated the script as it should have. After the correction to our table was made, SQL Compare worked fine, and saved us a great deal of time.
  
  Thank you for the assistance.

  LexDeveloper August 17, 2006 13:31

  - 0 +
• 
  Hi,
  
  I figured that SQL Compare must have been picking up that extra bracket from somewhere. I'm glad that you've figured it out!

  Brian Donahue August 18, 2006 12:36

  - 0 +

Add comment

Please sign in to leave a comment.