LinkedServer.LazySchemaValidation Property

Gets or sets the Boolean property value that specifies whether the schema used by the linked server data is validated when the local instance of SQL Server is idle or not.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property LazySchemaValidation As Boolean 
    Get 
    Set
'Usage
Dim instance As LinkedServer 
Dim value As Boolean 

value = instance.LazySchemaValidation

instance.LazySchemaValidation = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool LazySchemaValidation { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool LazySchemaValidation {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member LazySchemaValidation : bool with get, set
function get LazySchemaValidation () : boolean 
function set LazySchemaValidation (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the schema used by the linked server data is validated when the local instance of SQL Server is idle or not. If True, the schema is validated when the instance is idle.If False (default), the schema is validated when the data is accessed.

Examples

Using Linked Servers in SMO

See Also

Reference

LinkedServer Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Linked Servers (Database Engine)

sp_addlinkedserver (Transact-SQL)