Using an AutoIncrement coumn as part of a multi column primary key

[SBendBuckeye]

Hello all,

I have an MDI application which needs to track historisity so a user can go back and select a prior point. I would like to implement this as a multicolumn key with the high order part a Guid (column ID) and the low order part an autoincrement integer (column Revision#). That way I can let Sql Server handle the increments.

My question is this, is there a way to do this in the context of a multicolumn primary key? What I would want to have happen is for the Revision# column to be set/reset to 0 whenever the ID column changes.

Is there a better way? Any ideas and/or suggestions would be greatly appreciated!

Have a great day!

j2consulting@yahoo.com

 

[jbenson001]

You would not be able to use an Identity column in this case. You will have to use a trigger or stored procedure to check if the ID has changed and then increment and set the value manually.

Jim