.png)
Server.GetPropertyNames Method
SQL Server 2012
Returns the names of the initialized properties for the specified object type
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
'Declaration Public Function GetPropertyNames ( _ typeObject As Type _ ) As StringCollection 'Usage Dim instance As Server Dim typeObject As Type Dim returnValue As StringCollection returnValue = instance.GetPropertyNames(typeObject)
Parameters
- typeObject
- Type: System.Type
A Type system object that specifies the type of object.
Return Value
Type: System.Collections.Specialized.StringCollectionA StringCollection system object that contains a list property names for the specified object.
Visual Basic
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display all the loaded properties for the Server type.
Dim s As String
Console.WriteLine("===Before State property is accessed.===")
For Each s In srv.GetPropertyNames(srv.GetType)
Console.WriteLine(s.ToString)
Next
'Access the State property of the Server object.
Console.WriteLine(srv.State)
'Again, display the loaded properties for the Server type.
Console.WriteLine("===After State property is accessed.===")
For Each s In srv.GetPropertyNames(srv.GetType)
Console.WriteLine(s.ToString)
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host "===Before State property is accessed.==="
foreach ($s in $srv.GetPropertyNames($srv.GetType()))
{
Write-Host $s
}
Write-Host $srv.State
Write-Host "===After State property is accessed.==="
Foreach ($s in $srv.GetPropertyNames($srv.GetType()))
{
Write-Host $s
}
