Daily Archives: September 27, 2013

Home »  2013 »  September »  27th (Friday)

mssql DB 접속자 및 IP확인

SELECT S.SPID, S.LOGINAME, S.LOGIN_TIME, S.LAST_BATCH, C.CLIENT_NET_ADDRESS
FROM sys.sysprocesses S, sys.dm_exec_connections C
WHERE S.spid = C.SESSION_ID

mssql 에러 로그 확인 쿼리

sp_readerrorlog

IIS 동기화 ( freesync 이용)

http://sourceforge.net/projects/freefilesync/  굿잡!