I have a database name (temp).When i execute sp_fulltext_database in query
analyzer,it shows error as :
Msg 201, Level 16, State 4, Procedure sp_fulltext_database, Line 0
Procedure or Function 'sp_fulltext_database' expects parameter '@action',

I have two servers that are exactly the same:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
    Apr 14 2006 01:12:25
    Copyright (c) 1988-2005 Microsoft Corporation

I have successfully set up a full text search app that passes a search
string as a parameter to a stored procedure that uses CONTAINSTABLE. I would
like to be able to make the boolean logic a little more complex. Right now i
am limited to simple strings such as ......"electrical ...

I am having a problem with the following stored procedure. I would like to
update the state and zip code fields in the contacts table with the passed
parameters only of the zip code has been found in the ResumeDoc field in the
Resumes table. Unfortunately this sp updates all ...