ALTER PROCEDURE [dbo].[sp_TestSetupObjectsUpdate] @TestSetupId int = 0 ,@TestObjectId int = 0 ,@TestObjectName nvarchar(255) ,@TestSetupName nvarchar(255) ,@TargetSampleRate float ,@ExcitationWarmupTimeMS int ,@LocalOnly bit ,@TestObjectType nvarchar(50) ,@TestObjectPosition nvarchar(50) ,@DisplayOrder int ,@errorNumber int output ,@errorMessage nvarchar(250) output AS BEGIN set @errorNumber = 0; set @errorMessage = space(0); begin try if(@TestObjectName is null) begin set @errorMessage = 'An invalid parameter or option was specified for procedure' set @errorNumber = 15600 end else begin if(@TestObjectId=0) begin set @TestObjectId = dbo.foo_IdGetTestObject(@TestObjectName) end update [dbo].[TestSetupObjects] SET [TargetSampleRate] = @TargetSampleRate ,[ExcitationWarmupTimeMS] = @ExcitationWarmupTimeMS ,[LocalOnly] = @LocalOnly ,[TestObjectType] = @TestObjectType ,[TestObjectPosition] = @TestObjectPosition ,[DisplayOrder] = @DisplayOrder WHERE TestObjectId = @TestObjectId end end try begin catch set @errorMessage = error_message() set @errorNumber = error_number() end catch; END