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')