Never been there and I ain't gonna start today .

Looks like I read too fast... I were under the impression that you were in a rebuild of the server or something of the sort... That could have helped but...

You can always create a new column with identity, delete the old column and matching keys/objects.  Then rename the old column.

Now if you need to keep the old values just...

Have you tried running the copy in safe mode??

Maybe that'll allow you to finish this task ASAP.

Congrats guys.  The funny thing about this is as I was reading this article, the song Goodbye my lover from James Blunt started playing and it sure seemed fitting (not...

Sorry for the delay.  I had forgotten about your question.

There is no equivalent to tht in sql server.

You have to do an inner join on the 2 tables to get...

Keep his phone number in your black book... it might be handy for me one day .

Why not just have a datetime column with a default of getdate() ???

Why would you get flack for this (never worked on big projects here)??

Thanx again Sergiy.  Now let's no go in the datatype problems for now.  We'll wait for him to complain about an intermitant slow query.  Then we'll tell him about the comvert_implicit...