disable identity

• pedro.ribeiro

  Hall of Fame

  Points: 3201

  More actions

  May 14, 2009 at 10:01 am

  #204363

  Hi masters,

  how can i disable a identity column (the identity property)?

  and then later enable it , again?

  tks,

  Pedro

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  May 14, 2009 at 10:11 am

  #994674

  SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }

  looked it up in BOL

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life