Any suggestions? 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 Sub SetDefaultInitFields (
	typeObject As Type,
	allFields As Boolean


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
© 2016 Microsoft