Sergey

here the code that I cannoct send with pass through:

CREATE PROCEDURE dbo.sp_NextInternalNumber @tcTableName char(50), @tcNextLfdNr char(10) output AS
begin
        declare @lcNextNumber char (10)

        begin transaction
              /* Naechste laufende Nummer aus internenummnern holen! */
              select @tcNextLfdNr =  intnr from internenummern where inttabelle = @tcTablename

              /* Überprüfung, ob lfdnr gefunden wurde*/
              if not (@tcNextLfdNr > space(10) or @tcNextLfdNr > '')  -- goto ivs_NeueLfdNr 
              begin
                 /* Es wurde kein Eintrag gefunden, deshalb:  Naechste laufende Nummer aus internenummnern für NUMMERNKREIS holen! */
                 select @tcNextLfdNr =  intnr from internenummern where inttabelle = 'NUMMERNKREIS'

                 /* Kein Eintrag in Nummernkreis?*/
                 if not(@tcNextLfdNr > space(10) or @tcNextLfdNr > '') -- goto ivs_Nummernkreis
                 begin
                     /* Datensatz 'NUMMERNKREIS' anlegen */
                     insert into internenummern (IntTabelle, IntNr) values ('NUMMERNKREIS','         1')		
                     select @tcNextLfdNr = '         1' 
                 end	
                 /* Datensatz für benötigte Tabelle anlegen*/
                 --ivs_Nummernkreis:
                 set @lcNextNumber =  rtrim(lTrim(cast((cast(@tcNextLfdNr as bigint) +1) as char(10))))
                 set  @lcNextNumber =space( 10-len(@lcNextNumber)) + @lcNextNumber
                 insert into internenummern (IntTabelle, IntNr) values (@tcTablename, @lcNextNumber)
               end
               else
               begin
                  /* Naechste laufende Nummer in internenummnern speichern! */
                  --ivs_NeueLfdNr:
                  set @lcNextNumber =  rtrim(lTrim(cast((cast(@tcNextLfdNr as bigint) +1) as char(10))))

                  set  @lcNextNumber =space( 10-len(@lcNextNumber))+@lcNextNumber
                  /*update internenummern set intnr = intnr + 1  where inttabelle = @tcTablename */
                  update internenummern set intnr = @lcNextNumber  where inttabelle = @tcTablename 
               end
        commit
        return (1)
end

The error I get is: sql parameter is missing.
With cut and paste in Entprise Manager od Query Analyser it works fine.

Regards
>Hi Jörg,
>
>We're using SPT to create a bunch of stored procedures and they always work. Can you provide more details about once that don't work? What error do you get in such case?
>
>>You are right and I must have been blind! But some of them still don't work. But they do if I transfer them by 'cut and paste'. Strange isn't it?!
>>