Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identity column contains invalid INCREMENT

Status
Not open for further replies.
sweetleaf

sweetleaf

Programmer
Jan 16, 2001
439
CA
I'm using ERwin and when I try to create my tables in SQL Server I get the error msg:"Identity column contains invalid INCREMENT". My identity column is an integer(IDENTITY 0,0).

does anyone know how to fix this?
 
Sort by date Sort by votes
its ok, i've figured it out. in erwin blank out the identity value. so, instead of 0,0 just leave blank.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
920
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
901
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Update another column if text in another exists 2
Replies
4
Views
304
Cpreston
Cpreston
EM1107
  • Locked
  • Question
Converting data from rows to column.
Replies
12
Views
425
EM1107
EM1107
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
398
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top