id summary reporter owner description type status priority component severity resolution keywords cc release 12879 RecentChanges Macro anonymous "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." defect new normal MsSqlBackendPlugin normal