[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'limit'.

Please try the following:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/418.8 (KHTML, like Gecko) Safari/419.3
Remote Address 128.189.172.96
Referrer http://nzmusic.com/forum.cfm?i=13
Date/Time 26-Sep-06 10:27 AM

While trying to get into the Top 5's forum