July 15, 2007 at 2:00 am
i run a job portal
i want to enable full text search for a particular column
iam using sql server 2005
coumn name is "jobdescription" its type is ntext
i want to enable that column for full text search how can i do that, iam having very limited tools, i cannot connect using enterprise manager
all i can do that is via querys
any ideas???
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
July 15, 2007 at 6:48 am
can any one tell me atleast 2,3 queries atleast to get started.
iam trying queries , it says you dont have permission to set full text index.
i will need some correct queries so that i can argue with the hosting services.
if my queries are wrong , then that wud be a problem
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
July 16, 2007 at 1:40 am
Have a look in Books online. There's a section on full text search.
Full-Text Search Concepts (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm) should get you started.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2007 at 1:51 pm
thank you gila, but my hosting co. now says there sql server dont support full text search
damn what a waste of time
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply