April 16, 2008 at 12:51 pm
I created a full text index about two hours ago, now I cannot stop populating it, cannot stop logging changes, and I cannot delete the full text index. sp_Who2 shows the process blocking these attempts as 'FT GATHERER' running in the backgroud and I cannot kill this process. How do I get rid of this full text index? I am using SQL Server 2005.
April 16, 2008 at 1:26 pm
Did you try stopping full text service and then performing delete index thru SSMS?
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 16, 2008 at 1:34 pm
I guess it was doing a rollback of the populate, but it finally cleared itself up. But the answer to your question is yes, that was one of the first things I tried. I got an error saying that the service could not be stopped.
April 16, 2008 at 3:29 pm
Good to learn its resolved. 🙂
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply