Heh - I got burnt with ISNUMERIC just today - had some dodgy character data and thought it might just work to test which records I could convert to int,...

Interesting - I went with DML, but thinking about it now, it seems more like a hybrid that's both DDL and DML.

Can you fire a DDL trigger when...

anthony.green (7/19/2012)

---

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to...

Divide and conquer by extracting each set of records to its own file. Then import each file into the relevant table.

You can use a utility to extract each set...

If you're using SSIS to import the data via a flat file connection manager, then there is a setting in it's properties that may help. On the "general" section...