Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_buddy
Starting Member
41 Posts |
 Posted - 2009-03-05 : 01:13:49
|
| we have upgraded sql 2005 to sql 2008its compatiblity level is 90i want to remove digits from the noise word list,but after removing the it messgs still shows the digits as the noise words, i am not sure wether after upgrading to sql 2008 the stop list will come in effect or the noise word list,noise word list shows no impact even after changing.so should i increase the compatiblity level of database to 100 and alter the stop list or any other way could workwhat the compatiblity levl does? |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-03-05 : 01:22:41
|
| what u mean to saynoise word list.............? |
 |
|
|
sql_buddy
Starting Member
41 Posts |
Posted - 2009-03-05 : 04:17:24
|
| there remain a noise word file in sql 2005 in different culture(eg..english ) i am finding that in sql 2008 version also but not sure wether it is implemented or not |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-05 : 05:06:59
|
| I think 2008 version doesn't use noise words |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-05 : 05:07:42
|
| Here, go thru this..http://msdn.microsoft.com/en-us/library/ms142551.aspx |
|
|
|
sql_buddy
Starting Member
41 Posts |
Posted - 2009-03-05 : 05:38:29
|
| i know sql 2008 does not use noise words ,it uses stoplist but the message it shows , like ' the query contains 2 noise words' and i am also finding the noise word file of different culture in sql 2008 |
|
|
|
|
|
|
full text index not updating