I am getting this error when I activate the plugin in WP 2.9.2
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 1018 [code] => 1018 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. ) )
WordPress database error: [1]
show index from wp_posts
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 102 [code] => 102 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'post_title'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'post_title'. ) )
WordPress database error: [1]
ALTER TABLE wp_posts ADD FULLTEXT yarpp_title
( post_title
)
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 102 [code] => 102 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'post_content'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'post_content'. ) )
WordPress database error: [1]
ALTER TABLE wp_posts ADD FULLTEXT yarpp_content
( post_content
)