Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Identity on Uniqueidentifier RE: Identity on Uniqueidentifier

  • April 1, 2015 at 9:24 pm

    #1788179

    tomy200501 (4/1/2015)

    Hello All,

    I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier as a type and has a primary key constraint on it. Is this possible? If yes, could anyone please help with pointers.

    Thank you,

    To be totally honest, using a UNIQUEIDENTIFIER as a Primary Key opens a world of hurt on you, especially if the PK is also the clustered index. I'd avoid it, if possible.

    Perhaps we can help. Why do you think you need GUIDs (which are no longer guaranteed to be unique across multiple machines, btw).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)