Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Server.SetDefaultInitFields Method (Type, Boolean)


Specifies all the properties are fetched when objects of the specified type are instantiated.

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

public void SetDefaultInitFields(
	Type typeObject,
	bool allFields


Type: System.Type

A Type system object value that specifies the type of object.

Type: System.Boolean

A Boolean value that specifies whether all the properties are fetched when objects are instantiated.

If True, all the properties are fetched when objects are instantiated.

If False, all objects are set to default behavior.

SMO optimization allows only the minimum properties to be loaded when an object is created. When uninitialized properties are accessed, SMO makes individual requests to load the information from the instance of SQL Server. You can use this method to adjust which properties are initialized for an object when it is first created to further optimize performance.

Visual Basic


$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$tb = new-object Microsoft.SqlServer.Management.Smo.Table
$typ = $tb.GetType()
$sc = $srv.GetDefaultInitFields($typ)
$srv.SetDefaultInitFields($typ, "CreateDate")
foreach ($tb in $db.Tables)
   Write-Host $tb.Schema,".",$tb.Name,".",$tb.CreateDate
$srv.SetDefaultInitFields($typ, $sc)
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft