View Single Post
  #2 (permalink)  
Old September 26th, 2008, 02:09 AM
mansar1 mansar1 is offline
Registered User
 
Join Date: Jul 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Use thsi command
Set Identity_Insert Column_name On

And read this satement carefully

If the value inserted is larger than the current identity value for the table, SQL Server automatically uses the new inserted value as the current identity value.

Mohd Azharuddin Ansari
Syntel Inc
Pune