>>Thanks. That did the trick. Please could I trouble you as to any thoughts on the second part of my proble: re: NewID() disabling while I'm doing the import?
>
>Can you use DBSETPROP() function to disable default before import and enable it thereafter?
Thanks, Sergey - that seems like a good idea. It made me think as well - I can probably use Alter Table ... drop/set default too. I'm just wondering which might be better.
On the other hand, I originally thought that I was getting this violation error because I had the default value, which turned out to be not the case, so now I'm wondering if my Insert Into statement wouldn't just override the NewID() function anyway, given that I'm stipulating the value of Zone #.
Anyway, you're a diamond, Sergey - don't go the way of all IT flesh and get run over by a bus :-)
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.