Database

select c.* ,t.name from tempdb.sys.columns c
INNER JOIN tempdb.sys.tables t
on (c.object_id = t.object_id
and t.name = '#tmp_table');

and t.name LIKE '#tmp_table%'

and t.object_id = OBJECT_ID('tempdb..#tmp_table')

select c.* ,t.name from tempdb.sys.columns c
INNER JOIN tempdb.sys.tables t
on c.object_id = t.object_id
where t.object_id = OBJECT_ID('tempdb..#tmp_table')

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165443[^]:

I am getting the following error when trying to do a contains search on an indexed table:

Msg 30046, Level 16, State 1, Procedure sp_fulltext_service, Line 163
SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

select * from table1 where contains (MyText, 'fire')
i checked to see and my index service is running, it is also using "Local Account" to run (same as the SQL Server Agent)

when i run the sp_fulltext_service 'restart_all_fdhosts' command, i get the same error as shown above.
Edited by - xrum on 09/15/2011 09:52:27