USP_SOURCEANALYSISRULE_VALIDATESMARTFIELDDELETE

CREATE procedure dbo.USP_SOURCEANALYSISRULE_VALIDATESMARTFIELDDELETE
(
  @SMARTFIELDID uniqueidentifier
)
with execute as caller
as
  set nocount on;

  if @SMARTFIELDID is not null begin
    if exists (select 1
               from dbo.[MKTSOURCEANALYSISRULEFIELDS]
               where [MKTSOURCEANALYSISRULEFIELDS].[SMARTFIELDID] = @SMARTFIELDID) 
      begin
        raiserror('The smart field cannot be deleted because it is being used by a source analysis rule.',13,1);
      end
  end

  return 0;