Actually original question (that I was answering) was

I have a table XYZ with 3 INT columns. There are 3000 records already in this table. Now I need a copy of...

SELECT INTO loses all your original indexes, constraints etc - much better to copy the structure of original table by scripting it, add the Identity column, rename old table, build...

Sort of conveniently omits the really tricky bit - the "and"

10129 = ten thousand one hundred and twenty nine

The rules for the "and" are rather complex ... e.g.

101202 = one...

Indeed.

I don't really agree - surely if the...

In addition to the other posts you will always have a "hotspot" on the last data page of a clustered index on and identity column - this is because the...

I surprised that the most obvious reason has not been given:

If your data file disk fails you can recover to the failure point in time with the last full backup...

Yes - I really think they should be warned ....

You...

OK - I guess I misunderstood your requirement - I thought it was just getting in the existing data you had a problem with. Your manual sequence table will probably...

Correct

If I understand you correctly the system will use Identity in the new database but your problem is pushing in existing data that already has ID's allocated via you manual...

select cast(cast(RAND()*100000 as int) as datetime) will give you a random date between 1 Jan 1900 and 16 oct 2173 - you can see the range from

select cast(cast(0*100000 as...

Windows is rubbish at file copying - back in the old Netware days it had optimised file copy commands (NCOPY) to copy between servers - in all the time Microsoft...

Assuming your fields are called RGB for RGB value and R, G & B for individual parts then

RGB = 65536 * R + 256 * G + B

This is because...

I think you have a duff backup - try taking a fresh backup.

Also for this sort of thing I would strongly recommend restoring first to a SQL server instance that...