Keld Laursen (VFL) (8/15/2012)
It is also worth noting that you have no method of resetting the identity counter for the table.Thanks for the question. I were fairly sure that I had it right before submitting, but the other choices listed had me re-check. And I were right 🙂
Very rightly pointed out Keld. Truncate resets the identity counter for the table..
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter