How to check SQL Server Authentication Mode using T-SQL and SSMS?

Dear Readers,

Check Out my new article on MSSQLTips.com
Visit MSQLTips
Thanks,
Jugal Shah