You can use below query, it picks all the connections from a host (ABC in this case) from sys.sysprocesses; creates a common statement to kill them; and then executes the...

once I faced a similar issue, turned out server was patched and after reboot, system date time settings were screwed and system itself was showing past date. Hence sql server...

If you are executing the script manually yourself then right click on result set area, click on 'save result as' and save your file in any format; if you are...

I did a lot of googling & it seems reinstalling/repairing .net won't do any good, I still need to fix this problem, any suggestions would be appreciated

taking manual log backup would break LSN chain and log shipping would not restore that backup, as a result log shipping would break.

For tackling transaction log space issues on databases...

LI_LOGIN is a sql account

SIDs are exactly same:

0x3DA4C364F7CBF54DB2E25F6C18376DC8

0x3DA4C364F7CBF54DB2E25F6C18376DC8

Yes, I can login and successfully issue select queries locally.

Thanks!