Enable/Disable IDENTIFY

• Ib Larsen

  Grasshopper

  Points: 24

  More actions

  November 5, 2004 at 11:54 pm

  #84091

  Is it possible to "Enable/Disable IDENTIFY" on a column. By using "ALTER TABLE" or a builtin stored procedure.

  I have to builtin this function in a C# program.

   

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  November 6, 2004 at 8:18 am

  #529187

  yes u can do a force insert as well.

  for futher details look in BOL for identity

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 6, 2004 at 1:59 pm

  #529189

  I believe Dinesh meant the same, however have a look at BOL for SET IDENTITY_INSERT ON/OFF. Should do what you want.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Ib Larsen

  Grasshopper

  Points: 24

  More actions

  November 7, 2004 at 10:33 pm

  #529214

  Thanks - that was what i was looking for!

  Ib