DELETE Procedure. How To Return A Value?

Hello,

I created a DELETE Stored Procedure in SQL 2005.
When calling this procedure from my server code (VB.NET in my case) I
need to know if the record was deleted or not.

How should I do this?

Should I make the procedure to return True or False? If yes, how can I
do this?

My Stored Procedure is as follows (I think it is ok):

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Content_DeleteContent]

  -- Define the procedure parameters
  @ContentName NVARCHAR(100),
  @ContentCulture NVARCHAR(5)

AS

-- Prevent extra result sets from interfering with SELECT statements.
SET NOCOUNT ON;

-- Declare and define ContentId
DECLARE @ContentId UNIQUEIDENTIFIER;
SELECT @ContentId = ContentId FROM dbo.Content WHERE ContentName =
@ContentName

-- Check if ContentId is Not Null
IF @ContentId IS NOT NULL
  BEGIN

    -- Check if ContentId is Null
    IF @ContentCulture IS NULL
                        BEGIN

                                -- Delete all localized contents from dbo.ContentLocalized
                                DELETE
                                FROM dbo.ContentLocalized
                                WHERE ContentId = @ContentId

                                -- Delete content from dbo.Content
                                DELETE
                                FROM dbo.Content
                                WHERE ContentName = @ContentName;

                        END
                ELSE

                        -- Delete localized content from dbo.ContentLocalized
                        DELETE
                        FROM dbo.ContentLocalized
                        WHERE (ContentID = @ContentID   AND ContentCulture = @ContentCulture)

  END

GO
Thanks,
Miguel