ALTER PROCEDURE [dbo].[sp_SoftwareFiltersInsert] @ISOCode CHAR (1), @Description NVARCHAR (255), @Frequency FLOAT, @LastModified DATETIME, @LastModifiedBy NVARCHAR (255), @errorNumber INT OUTPUT, @IsDefault BIT , @errorMessage NVARCHAR (255) OUTPUT, @new_id INT OUTPUT AS BEGIN SET NOCOUNT ON; SET @errorNumber=0 SET @errorMessage='' INSERT INTO [dbo].[SoftwareFilters] ([ISOCode],[Description],[Frequency],[LastModified],[LastModifiedBy],[IsDefault]) VALUES (@ISOCode, @Description, @Frequency, @LastModified, @LastModifiedBy, @IsDefault) SET @new_id = scope_identity(); IF(@@error != 0) BEGIN SET @errorNumber = error_number() SET @errorMessage = error_message() END END