My coworker Marc posted up a good introduction into the different server cursor models and you can see it here:

http://blogs.msdn.com/sqlqueryprocessing/archive/2009/08/12/understanding-sql-server-fast-forward-server-cursors.aspx