Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 26th, 2007, 11:56 AM
Registered User
 
Join Date: Oct 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Full Text timing out

I'm running into a a problem with Full Text searching. I've narrowed my code that produces the error down to this:

SELECT Content
FROM Text
JOIN CONTAINSTABLE(Text, Content, 'lake') AS A
ON A.[KEY]=Text.ID;

The first time I run it in the SQL query analyzer it sits there for about 30 seconds and then gives me "Timeout expired (error - 2147217871)." After the first query attempt I can run it as many times as I want and it will work fine (no errors) ... But if I wait for about 30 minutes and then try it again, it will give the the error again on the first try. I've tried using search words that exist and ones that don't exist in the db and they both give the same error, so it's not that it's trying to return too many rows.

I'm using Microsoft SQL Server 2005. Any help would be greatly appreciated. Thank you.
 
Old October 29th, 2007, 11:47 PM
Registered User
 
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi,
     sorry I dont know Idea for like first time It will take 30 minutes after that wiil work....
      and another question its returning too many rows...best u can try distinct with select statement.....I feel it may be work fine..
               thanks...





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to enable full text indexing sharvari_mothe SQL Language 1 July 3rd, 2007 09:32 PM
Setting up Full-Text Indexing Aaron Edwards SQL Server ASP 0 July 2nd, 2006 01:32 PM
"New Full-text Catalog" Disabled jdebelen SQL Server 2000 3 February 24th, 2005 06:53 AM
FULL TEXT SEARCH PROBLEM jadoger SQL Server 2000 0 July 13th, 2004 03:46 AM
Transfer Text/timing problem? LoriBee Access VBA 7 November 7th, 2003 03:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.