As mentioned in my update yesterday about spu_generateInsert there is a limitation on the TSQL PRINT function which limits the output to 8000 bytes.I'm about to try and make the procedure work within this limitation (a table I'm trying to script exceeds this), but in the meantime I've added an additional bit of error reporting which results in the final line in the messages window being displayed as:
-- ** WARNING: The data length for at least one row exceeds 8000 bytes. The PRINT command is limited to 8000 bytes (for more information see http://msdn.microsoft.com/en-us/library/ms176047.aspx). Do not trust this data. ** --
so at least the user is informed of the issue. Download the updated script here.As always, comments and suggestions are welcomed.