issue “sp_displaylogin <user>” and the default output is the messages tab/ panel instead of the result tab/ panel. Is this expected?
This is expected. Normally when running query, procs or functions, the default tab will be result set, however; for print statement, the default will be the messages tab. "sp_displaylogin" has print statement as return result, therefore; the messages tab shows.
