Setting Identity option for a field in table

• Jagan Kumar

  SSC Eights!

  Points: 805

  More actions

  December 18, 2003 at 9:22 pm

  #101816

  Hi guys,

  I think it is a bad idea to set identity option for a column in a table(master table/transaction table)

  It is ok if we are dealing with any tables of temporary use.

  comments please.

  Jag

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 19, 2003 at 2:32 am

  #487162

  Seems that this http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19410&FORUM_ID=23&CAT_ID=2&Topic_Title=Gurus%2C+please+help&Forum_Title=General

  is the same question, right?

  If so, we should continue there.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

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