Conversion failure on data generation

• 
  Hi Ken,
  
  As far as I'm aware, SDG is not going to cast or convert any data, so my best guess is that the column in question would probably be a computed column. Data Generator will still allow SQL Server to generate the data for any computed columns rather than attempting to generate it itself.
  http://www.red-gate.com/supportcenter/c ... generators

  Brian Donahue July 05, 2012 04:59

  - 0 +
• 
  SQL Server's syscolumns table will make it easier to find any computed columns using the IsComputed column. http://msdn.microsoft.com/en-us/library/ms186816.aspx

  Brian Donahue July 05, 2012 05:01

  - 0 +

Add comment

Please sign in to leave a comment.