The script below returns the following error on SQL 2005... why??? (works fine in 2008)
"Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application"
And here is the script...
IF (NOT EXISTS (SELECT 1 FROM sys.fulltext_catalogs WHERE name = 'FT_Stock'))
AND exists (select * from (select SERVERPROPERTY('IsFullTextInstalled') as test) x where test = 1 )
exec('CREATE FULLTEXT CATALOG FT_Stock WITH ACCENT_SENSITIVITY = ON')
Microsoft SQL Server 2005Microsoft SQL Server
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!