MSSQL Subset Insert scripts
search cancel

MSSQL Subset Insert scripts


Article ID: 230118


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


There are two identified issues with the script
1)     The line 1 “use” statement by default references the TARGET.   It must reference the SOURCE for the script to work properly

2)     The Informational message printed out after each Insert regarding the number of rows inserted to the table shows zero rows when referencing a Table with Identity.    The script line must be moved prior to the SET IDENTITY INSERT OFF statement, otherwise the @@ROWCOUNT gets zeroed out.    In the screenshot below, line 21 MUST be moved to before line 19 in order for the accurate @@ROWCOUNT to be generated to the log / standard out.   This is a general case only for those tables that have an IDENTITY column, where the script includes the ON and OFF statements.


Release : 4.9.1

Component : Subset




Download and install the latest subset patch build compatible with TDM 4.9.1 from below link: