Hello,
There are some king of lock that stop my search process over a FTS table indOfertaCliente.
The Query:
SELECT TOP 1 * FROM indOfertacliente
Works fine...but
SELECT * FROM CONTAINSTABLE(dbo.indOfertaCliente, (*),'polar', LANGUAGE 3082, 1)
returns timeout. Also i receive timeout when i try to disable de FTS index over the table.
Which resource can be locked? Where can i see it?
Sql 2005. SP1
Tahnks in advance
When you run it does the statement show as blocked?
Have a look at sys.dm_exec_requests for rows with blocking_session_id not null.
