Yes, as John says let you database generate this number, if you need to use the number in the front end then just have your procedure return it after the insert has completed.
CREATE PROCEDURE example_procedure
@UniqueFieldID INT OUTPUT
SET NOCOUNT ON
TheTable (Field1, Field2)
SET @UniqueFieldID = SCOPE_IDENTITY()
SET NOCOUNT OFF