January 13, 2011 at 12:46 pm
I am pushing data into a SQL database with a third party software. This software pushes data into an already existing table or creates the table if it doesn't already exist. My original data had some +inf and NAN values in it and it seems to have corrupted the SQL table. I dropped the table and cleaned up the original data. I can push to a new table name but I still can't push the data to the original table name. Is there another step I need to take to "purge" the table so I can recreate it?
Thanks
January 13, 2011 at 4:38 pm
So you literally ran a DROP TABLE statement on the original table, see that it's gone from sys.objects, and when you try to import into that original table name again it fails?
Do you have the associated error message?
Have you run a DBCC CHECKDB on the database containing that table?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply