how to add support for russian language to Full Text search?

Hi all.
I'm using MS SQL Server 2K SP3. I need to implement full text search in
Russian.
Now if I execute smth like:
Select id_article From Articles Where FreeText (*, N' some words in
russian ')
I get an error:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query
contained only ignored words.
though with english words it works OK.
Buy the way, russian is not present in master..syslanguages.
thanks,
vlad.
I've just changed 'default full-text language' parameter to 'neutral' and
still have the same problem...
vlad.
|||Hi!
Did you manage to solve the problem?
I also have the same problem - only my words are in croatian :-)
"vlad" <vlad@.august-n.com.ua> wrote in message
news:dn1ma5$1l05$1@.pandora.alkar.net...
> I've just changed 'default full-text language' parameter to 'neutral' and
> still have the same problem...
> vlad.
>

How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!Inline.
"Transam388" wrote:
> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)
> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).
> Once this is done does it require a restart of SQL?
No.
> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!

How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!
Inline.
"Transam388" wrote:

> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)

> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).

> Once this is done does it require a restart of SQL?
No.

> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!