IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupObjectMetaDataUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestSetupObjectMetaDataUpdate]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupObjectMetaDataUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestSetupObjectMetaDataUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestSetupObjectMetaDataUpdate]
	 @TestSetupName		nvarchar(255)
	,@ISOTestObject		char(1)
	,@PropName			nvarchar(255)
	,@PropValue			nvarchar(255)
	,@Optional			bit
	,@Version			float
	,@errorNumber		int				output
	,@errorMessage		nvarchar(250)	output

AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0);

	if(@TestSetupName is null)
	begin 
		RAISERROR(15600,-1,-1, '[sp_TestSetupObjectMetaDataUpdate]') /* Error 1560 - An invalid parameter or option was specified for procedure*/
	end
	else
	begin
		SET NOCOUNT ON;
		declare @TestSetupId  int
		set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)

		UPDATE [dbo].[TestSetupObjectMetaData]
		   SET [ISOTestObject]	= @ISOTestObject
			  ,[PropName]		= @PropName	
			  ,[PropValue]		= @PropValue	
			  ,[Optional]		= @Optional	
			  ,[Version]		= @Version	
		 WHERE [TestSetupId]	= @TestSetupId
	end
END
































GO