>If the a large VFP data with compound key have already been upsized and now resides in MSSQL but I want to create a new Identity column to use as primary key how can I assign the values for existing records? In VFP I could issue something like:
>
>REPLACE ALL newcolumn WITH RECNO()

Try...

declare @NewKey INT
set @NewKey = 1

UPDATE MyTable
SET NewField = @NewKey
,@NewKey = @NeyKey + 1

BOb