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

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)

public DataTable EnumLoginMappings()

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
Show:
© 2015 Microsoft