mssql dbcc repair

step
Exec sp_resetstatus 'DBNAME'

Alter Database DBNAME SET EMERGENCY

DBCC checkdb ('DBNAME')

Alter Databases DBNAME Set Single_User with
Rollback Immediate

DBCC CheckDB('DBNAME', Repair_Allow_Data_Loss)

Alter Database DBNAME Set Multi_User

MSSQL Restart

** reference 
running status with mssql 2005 above
select session_id, start_time, status,
command, percent_complete,
estimated_completion_time
from sys.dm_exec_requests
where session_id=53

single user error
SELECT request_session_id
FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID('DBNAME')

KILL 51

트렌젝션 로그 삭제 방법

BACKUP LOG [UCCommunicator_Demo] WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE ([UCCommunicator_Demo], TRUNCATEONLY)

2개의 다른 Server 에서 Query 방법

Select * from openrowset('SQLOLEDB', '원격 DB IP 주소'; 'sa'; 'password', 'Select * from 원격 DB명.테이블명) as a

시스템 정보 관련 프로시져 호출

sp_who
sp_who2
select * from master..sysprocesses