MsSQL dbname(Suspect)

EXEC sp_resetstatus dbname; ALTER DATABASE dbname SET EMERGENCY; DBCC checkdb('dbname'); ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE...

WSUS update error

win2012 80244010 wsus server busy, keep retry 80244019 rename SoftwareDistribution win2008 R2 80092004 missing KB4474419 KB4490628 80243004 let window...

SQL check client IP

select conns.client_net_address, conns.auth_scheme, sess.* from sys.dm_exec_sessions sess LEFT OUTER JOIN sys.dm_exec_connections conns on sess.sessio...