Problem with paging and MS SQL

am trying to get the index page going on my table I am using a table
on Micrsoft SQL Server, when showing a single row from the table it
works OK. but when accessing the index I am gettingthe following

ActiveRecord::ActiveRecordError: Incorrect syntax near '\.'.: SELECT