SQL script to check users auth. method for databases

I was testing different authentication methods the other day and needed to check which types of authentication methods was used to my Microsoft SQL Server databases by my test-users. Because I needed to double-check that my .NET application was authenticating with Kerberos, and wanted to see this from the SQL server itself, I made this [...]