Re: RAISERROR() NOT POUP MESSAGE ?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/07/04


Date: Thu, 7 Oct 2004 20:22:57 +0200


>I have used raiserror() in my Sql Query but its output is printing within the Query Analyzer and
>not showing Popup Message, any idea why ?

Because SQL Server is executing on a server machine, and REISERROR just submits to message to the
client application. It is then up to the client application to do whatever it wants with that error.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Luqman" <pearlsoft@cyber.net.pk> wrote in message news:uD3o8gJrEHA.3520@TK2MSFTNGP11.phx.gbl...
>I have used raiserror() in my Sql Query but its output is printing within the Query Analyzer and 
>not showing Popup Message, any idea why ?
>
> I am using MSDE on Windows XP, is that could be the reason ? or I have to install some Windows 
> Component ?
>
> Best Regards,
>
> Luqman
>
> 


Relevant Pages

  • Re: RAISERROR() NOT POUP MESSAGE ?
    ... > I have used raiserrorin my Sql Query but its output is printing within ... > the Query Analyzer and not showing Popup Message, ... Because that's how RAISERROR works. ...
    (microsoft.public.sqlserver.programming)
  • RAISERROR() NOT POUP MESSAGE ?
    ... I have used raiserrorin my Sql Query but its output is printing within ... the Query Analyzer and not showing Popup Message, ... install some Windows Component? ...
    (microsoft.public.sqlserver.programming)
  • Re: Zeichen escapen und Ergebnis von Abfragen in Variablen speichern
    ... Erik Griffin schrieb ... ... Das ganze soll im SQL Query Analyzer ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: Maximum length of VARCHAR
    ... You can find the option there in Query Analyzer ... It was the maximimum display length returned by SQL Query ... >> FROM LeadAttachments INNER JOIN Documents ON LeadAttachments.DocumentID ...
    (microsoft.public.sqlserver.programming)
  • Re: READTEXT liefert nicht den gesamten Inhalt des Text-Feldes
    ... Leider wird der Inhalt des Feldes auch in der Datei nicht vollstänständig ... Bemerkung: mit der Einstellung: "Ergebnisse in Text Strg+T" ... des Query Analyzer, ausgeschaltet werden kann? ... >> Was muss ich tun damit ich die Daten auch mit dem SQL Query Analyzer ...
    (microsoft.public.de.sqlserver)