I object.

The question presented in the email had:

mainkey int not null identity (-1,1)

but the code in the question and answer on the web site had:

mainkey int not null...

Looks like this topic has been dead for a while, but the subject seems to match what I am seeing.

We thought that the hardware of our existing sql server may...