• Jack - I have to ask - are you talking about conceptual PK's?

    I'm pretty sure you cannot have anything NULL in a primary key, at least not one actually enforced by SQL Server.

    Just curious.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?