SQL Server Developer Center >
SQL Server Forums
>
Getting started with SQL Server
>
Grid to Full Text
Grid to Full Text
- Have had a few replies to this query.
I can not convert to Full Text conversion ... i am doing coursework. Using Adventure Works Sample database can some one explain in a little more ABC language. In the drop down from dbo.publishers the Full Text Index is greyed out. How do i go from there to convert?
Please be patient.
Answers
- Looks like the database is not enabled for Full Text Search. Execute the following from a new Query window:
USE <database name> EXEC sp_fulltext_database 'enable'
And then check if the Full-Text option is still grayed out.
This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL- Proposed As Answer bySQLUSA Tuesday, November 03, 2009 7:16 PM
- Marked As Answer byJohn_Bristol Friday, November 06, 2009 1:22 PM
All Replies
- Looks like the database is not enabled for Full Text Search. Execute the following from a new Query window:
USE <database name> EXEC sp_fulltext_database 'enable'
And then check if the Full-Text option is still grayed out.
This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL- Proposed As Answer bySQLUSA Tuesday, November 03, 2009 7:16 PM
- Marked As Answer byJohn_Bristol Friday, November 06, 2009 1:22 PM
- Thnx Amit i have the 3 possible answers .. but due to work commit and another project i have been unable to use the information yet.Can u pss this on. I willreply ASAP with outcome.
John Farley
