title: SQL Server Stored Procedure is not raising error in my program
body: <pre><code>CREATE PROCEDURE [dbo].[spTest]
  @Pozitii varchar(max),
  @NrZile int
  
  AS   
  set @Pozitii = SUBSTRING(@Pozitii,0,LEn(@Pozitii))
  
  CREATE TABLE #Pozitii (part varchar(20) null)
  
  
  
  INSERT INTO #Pozitii(part) 
  SELECT part
  FROM dbo.SDF_SplitString(@Pozitii,',')
  
  
  if exists (SELECT * FROM #Pozitii)
   RAISERROR('asdf',16,-1)  
  else     RAISERROR('else',16,-1)  
  </code></pre>
  
  <p>So runing this SP in SQL like this</p>
  
  <pre><code>exec [spTest] '11,12,13,',1
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>(3 row(s) affected)
  Msg 50000, Level 16, State 1, Procedure spTest, Line 27
  asdf
  </code></pre>
  
  <p>Now if I run my procedure in delphi ( using an ADO object) </p>
  
  <pre><code>procedure TframePlanificatorPozitieComanda.Button5Click(Sender: TObject);
  begin
  
  
    try
      with dm.spTest do
      begin
        Close;
        Parameters.ParambyName('@Pozitii').Value := '11,12,13,';
        Parameters.ParambyName('@NrZile').Value := 1;
        ExecProc;
      end;
    except
      on E: Exception do
      begin
        ShowMessage(E.Message);
      end;
  
    end;
  end;
  </code></pre>
  
  <p>This code is not raising any errors?Any ideas why? </p>