SQL Messages returned after executing some SQL are truncated to 208 characters.
Example: We run a SQL similar to this -
PRINT 'INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isignored) VALUES '
+ '('
+ '''' + RTRIM((@obj_name)) + '''' + ','
+ '''' + RTRIM((@parent_obj)) + '''' + ','
+ '''' + RTRIM((@obj_xtype)) + '''' + ','
+ '''' + RTRIM((@obj_desc)) + '''' + ','
+ RTRIM((@total_columns)) + ','
+ RTRIM((@total_defaults)) + ','
+ RTRIM((@total_indexes)) + ','
+ RTRIM((@total_foreign_keys)) + ','
+ RTRIM((@total_primary_key)) + ','
+ RTRIM((@total_constraints)) + ','
+ RTRIM((@total_unique_keys)) + ','
+ '''' + RTRIM((@created)) + '''' + ','
+ RTRIM((@isignored))
+ ')'
The expected output is:
INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isignored) VALUES ('asi_actions','0','U','Table',9,2,0,0,0,0,0,'Aug 9 2010 4:17PM',1)
Instead the output I see is:
INSERT INTO X (obj_name, parent_obj, obj_xtype, obj_desc, total_columns, total_defaults, total_indexes, total_foreign_keys, total_primary_key, total_constraints, total_unique_keys, created, isigno
GO