how to make autoincriment key in ms sql which reset to 0 on every day start? : hey I hope you all will fine. I want to make auto_incriment key in ms sql which starts to 0 (zero) on every day start. can anyone tell me that query. thanx in advance  