IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[GetContentByReference]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
  BEGIN
    DROP PROCEDURE dbo.GetContentByReference
    PRINT ('Drop [GetContentByReference]')
  END