none
How to use Max function in DBCC CHECKIDENT

    Question

  •  In MSDN I found an example for forcing to chnage in current identity value

    Example:
    USE AdventureWorks;
    GO
    DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 30);
    GO


    How to use max function in  DBCC Statment

    LiKE DBCC CHECKIDENT ("HumanResources.Employee", RESEED, SELECT MAX(COLUM1) FROMHumanResources.Employee );

    Since employee  table in two different server  whcih  has two way replication that is why  we neee max valud that particulare column while reseeding

    Plz provide solution


    .Net Developer
    Friday, August 22, 2008 12:02 PM

Answers

All replies