Just wanted to double check something as I've only ever done this YEARS ago!
Currently got about 20 databases on a SQL2000 server which I'm copying (using the object method, NOT the Detach/Attach method) to a newer SQL2005 server.
Will the indentifiers of all records be preserved or are there some precautions to take?
Currently got about 20 databases on a SQL2000 server which I'm copying (using the object method, NOT the Detach/Attach method) to a newer SQL2005 server.
Will the indentifiers of all records be preserved or are there some precautions to take?