• I've just worked it out.

    Thanks for your help. I really appreciate it.

    Did - ALTER TABLE EOD_CAPITA_ENDOFDAY ADD UniqueID INT IDENTITY(1, 1)