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 2005 Forums
 Transact-SQL (2005)
 Fulltext Catalog help!!!!!

Author  Topic 

hjavaher
Starting Member

16 Posts

Posted - 2009-06-29 : 14:00:19
I am Having a problem with my Full Text Search Catalog. for some reason it stopped indexing changes to the table. when I was creating the catalog I used "WITH CHANGE_TRACKING AUTO" which should update the index on its own am I correct? It used to work but I have no idea what happen that since last night any new entries to the table does not get indexed?? it is driving me insane, I have tried to remove it and start over however it keeps giving me errors that I can not remove the catalog since it is depending on the index and wise versa. In case you have not guessed, I am a newbie to SQL so any help would be greatly appreciated. oh by the way I am using Sql 2005 express so I don't have the nice gui to go with.

Thanks,
Jason

hjavaher
Starting Member

16 Posts

Posted - 2009-06-30 : 19:06:14
any thoughts on the matter guys?
Go to Top of Page

EugeneZ
Starting Member

26 Posts

Posted - 2009-06-30 : 22:34:40
please post what the problem related errors you can see in the box event viewer and sql server error log
---

make sure you have installed fresh service pack
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089

and get free GUI -SQL Server Management Studio Express
Download @
https://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
Go to Top of Page

hjavaher
Starting Member

16 Posts

Posted - 2009-06-30 : 23:07:43
Hi Eugenez,
Thank you for trying to help me, This is a hosted SQL Database with IXWebHosting, I don't think I have access to the server logs or the event viewers. But I will call them up and ask them.

Thanks again,
Jason
Go to Top of Page

hjavaher
Starting Member

16 Posts

Posted - 2009-07-03 : 01:22:28
I have just found that I only have 0.93 MB left on my limit for the DB. Could this be the cause?

Thanks,
Jason
Go to Top of Page
   

- Advertisement -