[venkatesanj@hcl.in]

Sir,
Just make a try with identity column (seed value 0,1) - To check whether the problem is with auto generation.

Whether you are trying to insert the datas using NewID(). Please check my article for more reference.

http://venkattechnicalblog.blogspot....ql-server.html

Regards,
Venkatesan Prabu . J