Database

Quote:

Another oddity of the local temporary table (and the local temporary stored procedure) is that it has a different name in the metadata to the one you give it in your routine or batch. If the same routine is executed simultaneously by several processes, the Database Engine needs to be able to distinguish between the identically-named local temporary tables created by the different processes. It does this by adding a numeric string to each local temporary table name left-padded by underscore characters. Although you specify the short name such as #MyTempTable, what is actually stored in TempDB is made up of the table name specified in the CREATE TABLE statement and the suffix. Because of this suffix, local temporary table names must be 116 characters or less.

#tmp_table__________________________________________________________________________________________________________000000000002

where t.name LIKE '#tmp_table%'

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