Problem with Redgate SQL Source Control

• 
  This is perhaps not the clearest error message ever!
  
  It turns out SQL Source Control is reading your static data and looking for a string to insert into the first field (column 0) of your table, but it's finding a number (1). (Token types are different in each engine version, but 714 has been "Integer" in some recent versions).
  
  It sounds like your static data contains something like:

  INSERT INTO Foo (stringColumn, ...) VALUES (1, ...)
  

  
  I hope this helps you track down the issue, but it would probably be worth contacting support@red-gate.com for further help.

  sam.blackburn January 12, 2017 05:49

  - 0 +
• 
  I had this problem and the solution for me was to unlink from source control and then connect back up again.

  JamesHaydock June 13, 2017 12:56

  - 0 +
• 
  Hi @JamesHaydock
  
  Thanks for posting a solution. Glad that worked you.

  Sam J June 16, 2017 09:40

  - 0 +
• 
  @JamesHaydock I also will add my Thanks.  I had the same basic problem and this fixed worked for me.
  

  SemperFi89 March 26, 2019 15:37

  - 0 +
• 
  I just ran into this issue and the description provided by @sam.blackburn made it more clear. This  problem occurred after I changed a table with linked static data. I altered a column from int to varchar.
  

  dsbert January 16, 2020 21:25

  - 0 +
• 
  I had the same reproduction as dsbert.  Column in a statically linked table was changed from integer to string.

  Paddy March 31, 2021 11:51

  - 0 +
• 
  I've got the same problem and just unlinking the static data for the changed table helped 

  gioa February 24, 2023 10:51

  - 0 +

Add comment

Please sign in to leave a comment.