We recommend using Visual Studio 2017

DatabaseOptions.LocalCursorsDefault Property

Gets the Boolean value that specifies whether the local server cursors are used by default.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public bool LocalCursorsDefault { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether local cursors are used by default.If True, local cursors are used.If False (default), local cursors are not used and the cursors are implemented at the client.