MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server

Obtaining a FAST_FORWARD Cursor

Consumers can request different cursor behaviors in a rowset by setting certain rowset properties. If the consumer does not set any of these rowset properties or sets them all to their default values, SQLOLEDB implements the rowset using a default result set. If any one of these properties is set to a value other than the default, SQLOLEDB implements the rowset using server cursors.