Has anyone had any success using this plugin with WordPress On SqlServer?
I would appreciate any feedback you may have.
The specific error I have received is as follows:
Errors, Warnings, Notices
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 156 [code] => 156 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'AS'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'AS'. ) )
WordPress database error: [1]
SELECT COUNT(*) AS cnt FROM wp_posts WHERE ( (post_status = 'publish' AND (post_type = 'post' OR post_type = '')) OR (post_status = 'publish' AND post_type = 'page') ) AND post_password='' ORDER BY post_modified DESC
http://wordpress.org/extend/plugins/google-sitemap-generator/
