Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Unanswered: Have a major issue with Identity Specification...

    I need to make an auto increment primary key field in one of my tables, so I tried setting up the Identity Specification but it will not allow me to change the setting from NO to YES. I have tried just about every common sense approach but no success.

    So I re-created the table from scratch with no data, and I still cannot declare or set the identity specification on that specific field, primary key or not.

    Any help would be greatly appreciated. THANKS!

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Can you show us your code?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    How are you "setting up the identity specification?"

    Are you using the table designer in the SQL Server Management Studio?

    Which brings up another question . . .

    What version of SQL are you using?
    Ken

    Maverick Software Design

    (847) 864-3600 x2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •