Re: Error message in wrong language?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hilary Cotter (hilaryk_at_att.net)
Date: 08/21/04 

Date: Fri, 20 Aug 2004 22:43:35 -0400

are you getting this message in Query Analyzer? If so which language is it
being returned in?

Are you getting it in ADO? If so, what is your localeID, and what are your
regional settings (check control panel for this). 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"charles" <spam@synthigence.com> wrote in message
news:O$WT0wvhEHA.3200@TK2MSFTNGP10.phx.gbl...
> I want to give users access to full-text searching and presume that I can
> let SQL-server do all the dirty work.  If I pass in a syntax error, things
> fail as expected and I get an appropriate error message in the exception.
>
> If I pass in a query with only "a" (for example) with only ignored words,
> the exception is thrown with an error message in Spanish!
>
> "Una proposizione della query conteneva solo parole ignorate."
>
> Since syntax errors on the same stored procedure come back in English, I
> assume my culture is correct (and I set it explicitly).  If call the
stored
> procedure from DevStudio with the same params, the error message is in
> English.
>
> Any ideas?
>
> thanks
> charles
>
> DETAILS:
> The stored procedure:
> ALTER PROCEDURE dbo.GetMessageList
>
> (
>
> @ForumID int,
>
> @FullTextSearch nvarchar(200)='',
>
> @BeginDate DateTime=NULL,
>
> @EndDate DateTime=NULL,
>
> @IsModerator bit=0
>
> )
>
> AS
>
> SELECT
>
ForumMessages.ID,Title,MessageBody,Format,Locked,Importance,Hidden,PostTime,
> UpdateTime,EventDate,Alias,Views,
>
> (SELECT COUNT(ID) FROM ForumMessages AS F1 WHERE
> ForumMessages.ID=F1.RootParentID) AS Replies
>
> FROM ForumMessages, ForumUsers
>
> WHERE
>
> ParentID IS NULL AND
>
> ForumID=@ForumID AND
>
> (@IsModerator=0 OR Hidden=0) AND
>
> (@BeginDate IS NULL OR EventDate>=@BeginDate) AND
>
> (@EndDate IS NULL OR EventDate<=@EndDate) AND
>
> ForumUsers.ID=UserID AND
>
> (@FullTextSearch='' OR ForumMessages.ID IN
>
> (SELECT RootParentID FROM ForumMessages WHERE
> CONTAINS(Title,@FullTextSearch) OR CONTAINS(MessageBody,@FullTextSearch)
>
> )
>
> OR ForumMessages.ID IN
>
> (SELECT ID FROM ForumMessages WHERE CONTAINS(Title,@FullTextSearch) OR
> CONTAINS(MessageBody,@FullTextSearch)
>
> )
>
> )
>
> ORDER BY Importance DESC,UpdateTime DESC
>
> RETURN
>
>

Relevant Pages

  • Error message in wrong language?
    ... If I pass in a syntax error, ... fail as expected and I get an appropriate error message in the exception. ... Since syntax errors on the same stored procedure come back in English, ... FROM ForumMessages, ForumUsers ...
    (microsoft.public.sqlserver.fulltext)
  • Re: ADP Connection Timeout
    ... The query only returns about 70 ... but the stored procedure in query analyzer takes ~55 seconds. ... When I put in the longer running query, I get an error message. ... >>property) so I don't know how to modify timeout property. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Views inside Stored procedure
    ... You didn't post the reply from the query I asked you to run in my previous post. ... The error message that I'm getting is "Invalid Object Name ... I've tried it as a stored procedure also and go the same results. ... execute the view as a stand alone with no problems. ...
    (microsoft.public.sqlserver.programming)
  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: noise words, @@ERROR, and stop and resume indexing
    ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure. ...
    (microsoft.public.sqlserver.fulltext)