I need to create Insert scripts from the content of a table. To do that, I used the database tasks -> generate scripts.
The table is quite big and in the generated script, it adds PRINT command after each 100 number of rows and a GO statement. For example:
print 'Processed 9200 total records' GO
For some reasons I can't have GO and PRINT command in the script, repeated in the middle. Is there any way to avoid creating them in the generated script? It is really time consuming to go one by one and delete all PRINT xxxx statements.