Just a little question - how to create a fulltext index on MSSQL Server using PHP script.
I would have thought that
$result=do_query("ALTER TABLE enquiry ADD FULLTEXT (hotel_var)");
would have worked, but alas not... any ideas ?
Read the MS SQL docs.
Does MS-SQL even support FULLTEXT indexes?
Full-text indexes are nonstandard and vendor specific. You need to look in the MS SQL docs for ways to do this (hint you need to use Enterprise Manager).
Yeah tried that one, but no success, the option to do it is greyed out. I can see it, but can't use it. Any ideas ?
try hrough ODBC and see if it still craps...
my poor 0.02 US$...
Not got a clue how to start that one. Any ideas where to read to get a clue ?
yeah the manual.
create a DSN for your database on your webserver and access your DB through the DSN in ODBC. I have no idea how good the ODBC support is for MSSQL but it's worth a try...
Have you visited MSDN yet? What version of MS SQL are you running. It is not availible on all versions/classes.
Ahh - would that be the PHP manual (definately available) or the MSSQL manual (that I have asked my IT department for 100's of times, and is still very elusive) ?
I have looked a little on MSDN however.
MSSQL version 7
Standard? Enterprise? Desktop? What OS is it running on?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/textsearch.asp
