ticket,summary,type,release,owner,status,created,modified,_description,_reporter
12879,RecentChanges Macro,defect,,,new,2016-09-26T13:32:13+02:00,2016-09-26T13:32:13+02:00,"It looks like the RecentChanges macro isn't correctly converted from regular SQL to MSSQL as it's still trying to use the 'LIMIT' clause:

{{{
#!sql
Error: Macro RecentChanges(Trac,3) failed
('42000', ""[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'LIMIT'. (102) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (8180)"")
}}}


An example of this can be found on the default install of Trac under the following page: WikiFormatting#Macros when the MSSQL plugin is used.",anonymous