remove ignored words - full text catalog

hey
when i try to search an "noise word" it drop me an ERROR
what i have done :
- stop full text service
- remove the words i want ,from noise.enu , noise.eng , noise.dat (@.@.language = u.s...) the files is in system32 and in program files\...\config .
- start full text service
-rebuild and after that re populate the catalog

and it still drop me an ERROR !!! how can i resolve this prob ?

tnx tnx .

Why are you storing SQL Server Full Text file in System 32, you don't create the part SQL Server creates the part. You just create the Text and NText datatype and upload the file SQL Server creates an Arithmetic pointer to the file and I know it cannot be in System 32. System 32 is in Windows folder SQL Server will not get a file from Windows folder. Run a search for Full Text, Microsoft Search Service, Micorsoft Catalog and CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE in SQL Server BOL(books online). Hope this helps.|||

no , i don't store the catalog in system 32 , the noise.* files are in library system32 and in ...\config .
when u install sql server , it copy the noise.* files to those librarys .
and correct , i use CONTAINS , i doesn't allways get this error , only when i search "ignored word"

|||

Try this ' "ignored word" ' or ' "ignored Wor*" ' it may make a difference. Hope this helps.

|||hye
sooo it doesn't give me an error ,BUT it doesn't give the "correct" answer exp' :
the phrase : "windows cd"
----------------
the search phrase : "cd"
it return "windows cd" <-CORRECT
----------------
----------------
the search phrase : "*c*"
it return "windows cd" <-NOT CORRECT
----------------
i dont need to search in part of the word .
so how can i search "c" that won't give me "ignored words" error & will search like all other words (that won't search part of the word , like the exm')
tnx a_r .
|||There are noise words try this link for better queries and more about noise words. Hope this helps.
http://www.databasejournal.com/features/mssql/article.php/3454281|||tnx .
but how can i remove those "noise words" ? that it won't give me the error .|||You did not read the aritcle it shows you how to edit that file. Hope this helps.|||hey , i read the article & and i did more that what the article intracte to do . see the first post .

Remove "Select All" Options from Multi Select Parameter Dropdown

Hi All

I am using SQL Server 2005 with SP2. I have multi select parameter in the report. In SP2 reporting services gives Select All option in the drop down.

Is there any way I can remove that option from the list?

Thanks

No you can't remove it. It was removed by the MS team in SP1, but popular demand meant it was reinstated. The only way to get rid of it is to build your own UI.|||

FYI : the story is here

http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx

and here

http://blogs.msdn.com/bimusings/archive/2007/04/09/the-curious-saga-of-select-all-and-multi-valued-parameters-in-reporting-services.aspx

... note that in the followup comments in the first one, Brian W does note that:

re: Rather Ripped (Select All in Service Pack 1)

Sunday, February 04, 2007 5:49 PM by bwelcker

I understand all of the angst around this decision. We will definitely make this configurable in the future, either on a server level or a per-report level.

... after which somebody responds "I prefer per-server" -- but I personally (LSN) would prefer per-report. So they really can't win, can they <g>. No, seriously, in this case they can't win unless they do both...

>L<

|||

Thanks for the reply everyone.

That answers my question.

Regards

Remove "guest" account in SQL Server 2000

Is there any reason not to drop the "guest" account in a user database?
Thanks!Hi
If you wnat that anyone who has LOGIN access to the server access your db
as well , so do not remove it.
Why not having that every Login has a specific User account within the
database(s) that they need access?
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:E3985296-2D19-47C8-8051-37B664065AD6@.microsoft.com...
> Is there any reason not to drop the "guest" account in a user database?
> Thanks!|||The guest user us required in master and tempdb. Guest is disabled in other
databases by default. You can disable guest with sp_dropuser and enable
with sp_adduser.
Hope this helps.
Dan Guzman
SQL Server MVP
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:E3985296-2D19-47C8-8051-37B664065AD6@.microsoft.com...
> Is there any reason not to drop the "guest" account in a user database?
> Thanks!|||Dan
> databases by default. You can disable guest with sp_dropuser and enable
> with sp_adduser.
Can you elaborate a little bit about disabling 'guest' user? If I create a
new database the 'guest' is there.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OprfYbV2HHA.5380@.TK2MSFTNGP04.phx.gbl...
> The guest user us required in master and tempdb. Guest is disabled in
> other databases by default. You can disable guest with sp_dropuser and
> enable with sp_adduser.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
> news:E3985296-2D19-47C8-8051-37B664065AD6@.microsoft.com...
>|||> Can you elaborate a little bit about disabling 'guest' user? If I create a
> new database the 'guest' is there.
The guest user exists in all databases but is disabled by default in all
user databases. It can simply be ignored unless it needs to be enabled for
special reasons.
Note that dropping the guest user does not physically drop the user from the
database but only disables it. Only users who are explicitly granted
database access can access a user database when guest is disabled.
Similarly, adding the guest user enables it. Any login can access a
database with an enabled guest user. If the login was not explicitly
granted access, the guest user security context is used (which normally has
minimal public permissions).
Hope this helps.
Dan Guzman
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhtIOSY2HHA.4880@.TK2MSFTNGP03.phx.gbl...
> Dan
> Can you elaborate a little bit about disabling 'guest' user? If I create a
> new database the 'guest' is there.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:OprfYbV2HHA.5380@.TK2MSFTNGP04.phx.gbl...
>|||Thanks Dan for clarification.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23jiS2ab2HHA.3640@.TK2MSFTNGP06.phx.gbl...
> The guest user exists in all databases but is disabled by default in all
> user databases. It can simply be ignored unless it needs to be enabled
> for special reasons.
> Note that dropping the guest user does not physically drop the user from
> the database but only disables it. Only users who are explicitly granted
> database access can access a user database when guest is disabled.
> Similarly, adding the guest user enables it. Any login can access a
> database with an enabled guest user. If the login was not explicitly
> granted access, the guest user security context is used (which normally
> has minimal public permissions).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhtIOSY2HHA.4880@.TK2MSFTNGP03.phx.gbl...
>