Click here to Skip to main content
15,882,901 members
Home / Discussions / Database
   

Database

 
AnswerRe: View might cause corruption? Pin
Mycroft Holmes13-Jun-12 14:52
professionalMycroft Holmes13-Jun-12 14:52 
GeneralRe: View might cause corruption? Pin
kmoorevs14-Jun-12 4:20
kmoorevs14-Jun-12 4:20 
QuestionMySQL Pin
klaydze12-Jun-12 21:54
klaydze12-Jun-12 21:54 
AnswerRe: MySQL Pin
Bernhard Hiller12-Jun-12 23:34
Bernhard Hiller12-Jun-12 23:34 
GeneralRe: MySQL Pin
klaydze13-Jun-12 1:33
klaydze13-Jun-12 1:33 
QuestionRemove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.12-Jun-12 13:55
Fernando A. Gomez F.12-Jun-12 13:55 
AnswerRe: Remove a noise word in a SQL Server 2008 database Pin
Bernhard Hiller13-Jun-12 0:00
Bernhard Hiller13-Jun-12 0:00 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:05
Fernando A. Gomez F.13-Jun-12 5:05 
Hi, thanks so much for your help!

I finally managed to remove the noise words. It seems that MSSQLSVR2K8R2 (Uf!) has hardcoded somewhere (apparently some "resource" database, whatever that is) the noise words for each language. So, what I did was:

1.- Create my own stoplist[^]
2.- Through the SQL Management Studio, open the full-text index properties and then select the recently created stoplist rather than the default.
3.- Alter[^] the stoplist and drop the noise word.
4.- Re-index the full-text index.

Thanks again for your help! Smile | :)
AnswerRe: Remove a noise word in a SQL Server 2008 database Pin
Eddy Vluggen13-Jun-12 1:24
professionalEddy Vluggen13-Jun-12 1:24 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:06
Fernando A. Gomez F.13-Jun-12 5:06 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Eddy Vluggen13-Jun-12 5:48
professionalEddy Vluggen13-Jun-12 5:48 
AnswerRe: Remove a noise word in a SQL Server 2008 database Pin
Bernhard Hiller13-Jun-12 4:40
Bernhard Hiller13-Jun-12 4:40 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:07
Fernando A. Gomez F.13-Jun-12 5:07 
GeneralRe: Remove a noise word in a SQL Server 2008 database Pin
Fernando A. Gomez F.13-Jun-12 5:08
Fernando A. Gomez F.13-Jun-12 5:08 
QuestionSQL Compound Primary Keys Pin
Kevin Marois12-Jun-12 11:36
professionalKevin Marois12-Jun-12 11:36 
AnswerRe: SQL Compound Primary Keys Pin
PIEBALDconsult12-Jun-12 16:45
mvePIEBALDconsult12-Jun-12 16:45 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois12-Jun-12 18:13
professionalKevin Marois12-Jun-12 18:13 
GeneralRe: SQL Compound Primary Keys Pin
PIEBALDconsult13-Jun-12 4:10
mvePIEBALDconsult13-Jun-12 4:10 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois13-Jun-12 6:33
professionalKevin Marois13-Jun-12 6:33 
JokeRe: SQL Compound Primary Keys Pin
Eddy Vluggen13-Jun-12 1:21
professionalEddy Vluggen13-Jun-12 1:21 
AnswerRe: SQL Compound Primary Keys Pin
Jörgen Andersson12-Jun-12 21:56
professionalJörgen Andersson12-Jun-12 21:56 
GeneralRe: SQL Compound Primary Keys Pin
Kevin Marois13-Jun-12 6:34
professionalKevin Marois13-Jun-12 6:34 
AnswerRe: SQL Compound Primary Keys Pin
Eddy Vluggen13-Jun-12 1:19
professionalEddy Vluggen13-Jun-12 1:19 
AnswerMaybe look at Set IDENTITY_INSERT On/Off Pin
David Mujica13-Jun-12 2:56
David Mujica13-Jun-12 2:56 
QuestionAccessing Oracle database Pin
Dangermouse9912-Jun-12 3:37
Dangermouse9912-Jun-12 3:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.