Today , I found my server could not be connected by Remote Desktop Connection. Google + Baidu , One solution is feasible:
1. Telnet the server
2. Show all user (use "query user" on the console interface)
3. Logoff unwanted user, OK!
But, unfortunately, my telnet was not open ! at last, MS SQL Server helped me faultlessly. Share the way with you:
1.Open the "Query analysis"
2.Input xp_cmdshell "your command words" ( As the solution)
Powerful xp_cmdshell, fearful xp_cmdshell !
05/21/06 06/19/06 06/21/06 06/23/06 06/26/06 06/27/06 06/29/06 07/02/06 07/05/06 07/10/06 07/27/06 07/30/06 08/01/06 08/06/06 08/07/06 08/09/06 08/12/06 08/18/06 09/14/06 09/21/06 09/26/06 09/27/06 10/03/06 10/04/06 10/05/06 10/06/06 10/07/06 10/22/06 10/25/06 10/26/06 10/28/06 10/29/06 10/30/06 10/31/06 11/05/06 11/06/06 11/07/06 11/08/06 11/09/06 11/11/06 11/18/06 12/02/06 02/19/07