Query Windows Authentication or SQL Server Authentication

• MSSQL_NOOB

  SSCommitted

  Points: 1605

  More actions

  December 21, 2012 at 3:14 pm

  #393831

  Is there a query that looks for a view / master / sys tables that will return usernames and method of authentication?

  for example:

  abc\def windows

  abc\eft sql server

  ...

  etc