Server: Msg 7619, Level 16, State 1, Line 1 
Author Message
 Server: Msg 7619, Level 16, State 1, Line 1
Does anybody know something about this message?

thank you
michael



Fri, 15 Feb 2002 03:00:00 GMT
 Server: Msg 7619, Level 16, State 1, Line 1

Hi

I believe that you have not so much use of this message, doesn't say much...
But one important thing is that the error occured inside an EXECUTE
statement.

Might that be the case?

/JR



Quote:
> Does anybody know something about this message?

> thank you
> michael



Fri, 15 Feb 2002 03:00:00 GMT
 Server: Msg 7619, Level 16, State 1, Line 1
Yes you are right
The Procedure is full-text based and looks like this.

CREATE PROCEDURE [Prod_test]
  /* PARAM LIST */

AS

   BEGIN

  /*AUSWAHL BER DIE PRODUKTSUCHMASKE*/


Produkte.JapReg_id,
      Produkte.Handelsname_eng AS PRODUKTHANDELSNAME,
      produktinfo.Beschreibung_eng AS PRODUKTINFO,
      JapReg.Name_eng AS JAPANREGISTRATION,
      Division.DName AS DIVISIONNAME,
      RohstoffKat.Beschreibung_eng AS ROHSTOFFKATEGORIE,
      produkte_rkat.ROHKAT_ID, prod_inci.INCI_ID,
      INCI_CHEM.IName_eng AS INCI_CTFA, Produkte.Information,
      ServicePak.USERID, ServicePak.SPAK_ID
  FROM Benutzer FULL OUTER JOIN  ServicePak ON
      Benutzer.USERID = ServicePak.USERID FULL OUTER JOIN
      JapReg FULL OUTER JOIN
      Produkte FULL OUTER JOIN
      produkte_rkat ON
      Produkte.PROD_ID = produkte_rkat.PROD_ID ON
      JapReg.JapReg_ID = Produkte.JapReg_id FULL OUTER JOIN
      INCI_CHEM FULL OUTER JOIN
      Division ON
      INCI_CHEM.DIVISION_ID = Division.DIVISION_ID FULL OUTER JOIN
      prod_inci ON INCI_CHEM.INCI_ID = prod_inci.INCI_ID ON
      Produkte.PROD_ID = prod_inci.PROD_ID AND
      Produkte.DIVISION_ID = Division.DIVISION_ID FULL OUTER JOIN
      produktinfo ON Produkte.PROD_ID = produktinfo.PROD_ID ON
      ServicePak.Prod_id = Produkte.PROD_ID FULL OUTER JOIN
      RohstoffKat ON
      produkte_rkat.ROHKAT_ID = RohstoffKat.ROHKAT_ID


end

No I need the return value of this procedure, to call an alternative
procedure which will return results when using a like factor

mybe you have got an idea, how to catch the value of the server message
"Server: Msg 7619, Level 16, State 1, Line 1
The query contained only ignored words."

Quote:

>Hi

>I believe that you have not so much use of this message, doesn't say
much...
>But one important thing is that the error occured inside an EXECUTE
>statement.

>Might that be the case?

>/JR



>> Does anybody know something about this message?

>> thank you
>> michael



Fri, 15 Feb 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Server: Msg 7619, Level 16, State 1, Line 2

2. Server: Msg 7619, Level 16, Part II

3. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

4. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

5. Server: Msg 8114, Level 16, State 1, Procedure co_AddTrader_Information, Line 0

6. Server: Msg 4425, Level 16, State 1, Line 1

7. Server: Msg 1776, Level 16, State 1, Line 1

8. Server: Msg 214, Level 16, State 2, Procedure sp_execute, Line 52

9. Server: Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 94

10. Server: Msg 7354, Level 16, State 1, Line 1

11. Server: Msg 4321, Level 16, State 1, Line 2

12. Server: Msg 7411, Level 16, State 1, Line 1


 
Powered by phpBB® Forum Software