sql_logins vs server_principals

While researching on the users in our production database, I had to write a script to manipulate the SQL Server jobs and their owners.

While writing that script I came to know that sql_logins lists only SQL logins (such as sa or any other SQL login) whereas server_principals is more comprehensive hence returns a row for every login (whether be SQL or Windows)

According to the MSDN documentation, server_principals may return following types of logins:

  • SQL login
  • Windows login
  • Windows group
  • Server role
  • Login mapped to a certificate
  • Login mapped to an asymmetric key

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s