Full text search workaround?

Me and a friend are setting up a .net project on a shared hosting server....the thing is, they dont seem to allow the use of full text search....when i connect to the server on Enterprise Manager, the option for "Create new catalog" is disabled.

we need to give users the ability to search by keywords......what's a good workaround for this without using FTS?

any advice?

thanks.

G.Create queries that use the wildcart % for all the fields you want to search in ...
Only way you can do it ...|||Here is a nice example of some searching logic.

http://weblogs.sqlteam.com/jeffs/archive/2004/11/02/2460.aspx|||

% wildcards work really slow u should be carefull...

find a way to use full text search.

sql

full text catalog on remote (shared) server

Can any one help - my Full text catalog on a remote shared sql server has
died and i need to recreate it completely - I have done this before but i've
lost the code to do it.
If I remember right what i did was use start --> run --> to run an exe in the
mssql folder that connected to the remote server - but i've lost all the
parameters I needed for it.
ANy help much apprectiated
Try this where d is the drive letter for your cd rom.
D:\SQL2000\x86FullText\MSSearch\Search\SearchStp.e xe /s /a:SQLServer
"niceguy" <niceguy@.hotmail.com> wrote in message
news:0001HW.BFA01CD1000E450DF0305550@.news.astraweb .com...
> Can any one help - my Full text catalog on a remote shared sql server has
> died and i need to recreate it completely - I have done this before but
> i've
> lost the code to do it.
> If I remember right what i did was use start --> run --> to run an exe in
> the
> mssql folder that connected to the remote server - but i've lost all the
> parameters I needed for it.
> ANy help much apprectiated
>