Hi all,
I've been asked to look at a server issue but for some reason I am unable to track down the cause.
Basically, they have SQL Server 2005 (Workgroup Ed) that has a number of databases running. One of which has Full Text indexing enabled on a table.
When trying to read the data regardless of what client I use, I get
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The only way to get it working again is by killing the process
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftesql.exe
I had to kill the process because I was unable to stop/restart the windows service
SQL Server FullText Search
By killing the process, it started working again.
I then rebuilt the index on the table and all was fine.
This morning i received another email stating that the problem was back. I was able to replicate the fix but I really need to work out whats going on.
Does anyone have any suggestions?
Cheers
Gavin