• dost.kumar your original question was:

    i want change the CId IDENTITY (1,3)..

    how can i alter the table..

    which is what resulted following my suggestion.

    Do you want your existing entries to maintain the values they had before changing the identity increment, with only new values having the new identity values or?

    Can you provide an example of what you want as your result?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]