IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_UserUIItemSettingsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_UserUIItemSettingsUpdate]
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_UserUIItemSettingsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_UserUIItemSettingsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_UserUIItemSettingsUpdate]
            @UserID			int
           ,@UIItemID		bigint
           ,@Permission		smallint
           ,@Visible		bit	
		   ,@errorNumber	int				output
		   ,@errorMessage	nvarchar(250)	output 
AS
BEGIN
	SET NOCOUNT ON;
	UPDATE [dbo].[UIItemSettings]
	   SET [UIItemID]			= @UIItemID	
		  ,[Permission]			= @Permission	
		  ,[Visible]			= @Visible	
	 WHERE [UserID]				= @UserID
END




























GO