This is just a quick reference about something very handy when you are doing development for data loading. Do you ever have the table design done, have all your foreign key set, and then you load the test data… over and over again, now you start with all those high number key in your table?
Yes, you can *truncate* table and it will all start new! But wait… if you have foreign key, you will get this error:
Server: Msg 4712, Level 16, State 1, Line 1
Cannot truncate table '[Table Name]' because it is being referenced by a FOREIGN KEY constraint.
Why? Because *trucate* first drop the table, then recreate the table!
Sure I can use delete from [table name], but the identity number just keep increasing!
Here is one easy command to reset the identity seed start number:
dbcc checkident ([table name], reseed, 1)
Keep in mind that please do not ever do this if your table is full of valuable data! If you reseed a identity column which happen to be your primary key column, guess what happen? next insert you are going to get a big fat error! 
Therefore, use it intelligently!
viagra cialis canada
keywords tramadol
order valium
www cialis
no perscription xanax
valium overnight
www adipex com
tramadol drug admin
viagra doses
tramadol florida pharmacy
tramadol dose rate
soma drug toxicity
in ingredient tramadol
lexapro and phentermine
identify real cialis
soma tri
flomax viagra
viagrafix corporation
viagra buy viagra
discountusdrugs.com hepsera soma
tramadol adverse reactions
soma music
snort xanax
generika levitra
free viagra samples
tramadol hydrochloride ultracet
phentermine.html
viagra indication
phosphodiesterase inhibitors viagra
overnight adipex
phentermine ionamin
levitra viagra compare
qoclick tramadol
tramadol norting
herb viagra
tramadol click here
adipex diet pills
tramadol 100 tablets
precaution soma
soma studios chicago
tramadol thomas method
raja soma
poker valium
line pharmacy phentermine
generic tramadol 377
phentermine buy wholesale
get prescribed xanax
discount generic viagra
cheap keyword tramadol
sertraline tramadol and
350mg soma weblog.ro
viagra discussion
levitra message board
valium online canada
tramadol and dentistry
valium addiction
without prescription tramadol
watson soma online
generic cialis overnight
phentermine diet pills
female viagra drug
tramadol 120 quantity
diet levitra
pharmacy soma
generic cialis cheap
drug screening tramadol
generic viagra cialis
medicine called tramadol
levitra link spammers.chongqed.org
shooting up xanax
phentermine shipped cod
viagra warning