Export (0) Print
Expand All

Database.EnumLoginMappings Method ()

 

Applies To: SQL Server 2016 Preview

Enumerates a list of SQL Server logins for all the users in the database.

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

member EnumLoginMappings : unit -> DataTable

Return Value

Type: System.Data.DataTable

A DataTable object value that contains a list of logon mappings to users in the database. The table describes the different columns of the returned DataTable.

Column

Data type

Description.

UserName

String

The name of the database user.

LoginName

String

The login account that is mapped to the database user in the referenced database.

Legacy Code Example

The example runs a server object enumeration method, but extracting the information from the datatable object is the same for database enumeration methods.

VB

Code snippet is not found. Confirm that the code snippet name 'SMO How to' is correct.

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$d = new-object System.Data.Datatable
$d = $srv.EnumCollations

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft