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