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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2001-12-18 : 09:22:02
|
| ratnesh writes "I am using SQL SERVER 2000 running on windows 2000 advanced server. I had a problem of ignore words while using contains clause on a full text index. It did not give me any error number in @@error variable.I looked into some forums and found a reply to install service pack for SQL SERVER 2000. The service pack did solve the problem. Now i get the error number in @@error variable. But now the problem is that the exectuion of the procedure where i have used my contain clause stops when it gets this error and does not go beyond that line where i have my error trapping routine.SELECT category_id, category_description FROM Mcategory_master WHERE CONTAINS(*, @strSearch) If @@error<>0 does not come to this line set @err = 1.Please help me regarding this." |
|
|
|
|
|