So I'm NOT as SQL expert by any means. Here is the scenario.1. I'm using a sql data base with MSFT RMS point of sale. I've used an import utility many times to import inventory into my data base using and.csv file. Done it many times with 100's of rows. I was testing my news import by grabbing, in this case 19 rows of data. I successfully imported the 19 rows and was ready to import the lion share 500 rows. Somehow the import previously has now made it so i can't import more than 19 rows. If i select 15 items, it duplicates row 15 4 times to maintain the 19 rows.
By chance I was in the process of swapping out the hardware that hosts the SQL database and upgrading my SWL server to server studio 2017 from a previous version. I thought this would solve my problem. Nope. Of course i can't start with a new database so to me, it's something in the database that has somehow throttled the ability to import anything more than 19.
I've gone to different workstations, same result. reinstalled new version of the import utility, same issue. Does anyone have any ideas, 1, WHAT THE PROBLEM IS? 2. HOW DO I FIX IT?
Thank you in advance.