ALTER PROCEDURE [dbo].[sp_TagsDelete]
			 @TagId			int
		   ,@errorNumber	int				output
		   ,@errorMessage	nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	DELETE FROM [dbo].[TagAssignments] WHERE [TagID]=@TagId
	delete from [dbo].[Tags] WHERE [TagId] = @TagId
END