Wish you all the best of luck in your new careers.

Many of the new tips and tricks were collected via sqlservercentral.com so i ow you guys a great deal

Thank guys for your feedback.

It seems Microsoft SQL Server has no direct answer for this issue, rather than drop and add the ID column again. (just like frank...