Share via


UserOptions.NoCount Property

Gets or sets the Boolean property value that specifies whether queries return the number of rows affected.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property NoCount As Boolean 
    Get 
    Set
'Usage
Dim instance As UserOptions 
Dim value As Boolean 

value = instance.NoCount

instance.NoCount = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")]
public bool NoCount { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"false")]
public:
property bool NoCount {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")>]
member NoCount : bool with get, set
function get NoCount () : boolean 
function set NoCount (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies the whether queries return the number of rows affected.If True, the number of rows affected by the query is not returned.If False (default), the number of rows affected by the query is returned.

Examples

Configuring SQL Server in SMO

See Also

Reference

UserOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Configuring SQL Server in SMO

NIB user options Option