>Thank you. I now created a permanent stored procedure (exactly as the temp one) but still the cursor is not updated. I even set the value to be OUTPUT in the stored procedure to some number but the Identity field still shows 0 after update. Could it be that the reason is the Identity field is the same as PK field?
Do you have another unique key in the table (as in this sample it's timestamp field)?
If it's not broken, fix it until it is.
My Blog