Shulou(Shulou.com)05/31 Report--

How to use xp_cmdshell logout Windows login users, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this to learn, I hope you can gain something.

Company daily project update using TFP, server general maintenance with remote desktop management, so often log on to the server, but sometimes due to some reason, log on to the server, the account did not log off in time, resulting in the back can not log on to the server,

display errors such as

Appear this kind of problem to return true trouble, run computer room smooth formalities to want 2 3 days ability to do well. Fortunately, the company has always kept Sa account,

This is easy to do, with SQL logout of a Windows login user can be.

xp_cmdshell--execute XP_CMDSHELL to open xp_cmdshellEXEC sp_configure 'show advanced options', 1RECONFIGURE WITH OVERRIDERECONFIGUREEXEC sp_configure 'xp_cmdshell', 1RECONFIGURE WITH OVERRIDERECONFIGURE

View current Windows logged in users

EXEC xp_cmdshell 'query user'

logout Administrator user with Id 2 EXEC xp_cmdshell 'logoff 2'

--Close xp_cmdshellEXEC sp_configure 'xp_cmdshell', 0RECONFIGURE WITH OVERRIDE RECONFIGUREEXEC sp_configure 'show advanced options', 0RECONFIGURE WITH OVERRIDE RECONFIGURE

Ok, done. Remote desktop again.

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.