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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 full text index error no 7619

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."
   

- Advertisement -