OleDbProviderSettings.AllowInProcess Property

SQL Server 2014

Gets or sets the Boolean property value that specifies whether the OLE DB provider is instantiated as an in-process server.

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool AllowInProcess { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether the OLE DB provider is instantiated as an in-process server.If True, the OLE DB provider is instantiated as an in-process server.If False (default), the OLE DB provider is instantiated as an external process.

Remarks

Instantiating the provider outside the SQL Server process protects the SQL Server process from errors in the provider. When the provider is instantiated outside the SQL Server process, updates or inserts referencing long columns (text, ntext, or image) are not allowed.

Examples

Using Linked Servers in SMO

Community Additions

ADD