In SQL2000, we created a script to make structure changes to 21 production tables while preserving their data by doing a drop and recreate. After running the script, we checked the tables in Enterprise Manager and noticed that 3 of the 21 tables had been partially truncated, i.e., of 54,311 rows, we saw 54,000. Have any of you ever noticed a similar occurrence? Thanks
Yes, depending on the criteria in the script. I recommend to always make a backup of the table before making changes to its structure. I also recommend that a good backup of the database always be present.
Not without an accompanying error of some sort. Did you run into any problems with the update? I haven't seen SQL Server simply drop data within properly configured scripts, no.
And I agree, backups should be taken prior to structural changes on a production system.
Do you have a backup that you can check for duplicates on? Depending on your script they could have been eliminated.
Or perhaps you recreated the tables with indexes that excluded the rows for insertion?
How about triggers rejecting the rows?
