I will do my own testing to verify, but does anyone know if it is still true for MSSQL Server 2005 that selectmethod needs to be set to "cursor"? I found this URL saying it is not:
http://www.mail-archive.com/ofbiz-user@incubator.apache.org/msg03000.html