Question: how to check users logged into sql server?
Answer: Click "Start," type "cmd" (omit the quotation marks here and throughout) into the search box and press "Enter."
Type "SQLCMD -L" at the command prompt to bring up a list of SQL Servers running on your network.
Type "CONNECT (server name)" at the command prompt.