구성 옵션 설정 (SP_CONFIGURE)
/* --------------------------------------------------
계정 생성
-------------------------------------------------- */
CREATE LOGIN [컴퓨터명\계정] FROM WINDOWS;
GO
ALTER SERVER ROLE SYSADMIN ADD MEMBER [컴퓨터명\계정]
GO
/* --------------------------------------------------
서버명 확인 및 변경
-------------------------------------------------- */
SELECT @@SERVERNAME;
GO
EXEC SP_DROPSERVER [기존 서버명], 'DROPLOGINS'
GO
EXEC SP_ADDSERVER [새 서버명],'LOCAL'
GO
/* --------------------------------------------------
버전 확인
-------------------------------------------------- */
SELECT @@VERSION
/* --------------------------------------------------
구성 옵션 설정
-------------------------------------------------- */
EXEC SP_CONFIGURE 'SHOW ADVANCED OPTIONS', 1
GO
RECONFIGURE
GO
EXEC SP_CONFIGURE 'BACKUP COMPRESSION DEFAULT', 1 -- 백업 압축
GO
EXEC SP_CONFIGURE 'BLOCKED PROCESS THRESHOLD (S)', 1 -- BLOCKED PROCESS 1초
GO
EXEC SP_CONFIGURE 'CLR ENABLED', 1 -- CLR
GO
EXEC SP_CONFIGURE 'MAX DEGREE OF PARALLELISM', 1 -- 병렬 처리
GO
EXEC SP_CONFIGURE 'MAX SERVER MEMORY', 10240; -- MAX 버퍼 캐시
GO
EXEC SP_CONFIGURE 'MIN SERVER MEMORY', 10240; -- MIN 버퍼 캐시
GO
EXEC SP_CONFIGURE 'REMOTE ADMIN CONNECTIONS', 1; -- DAC 관리자 연결
GO
EXEC SP_CONFIGURE 'OLE AUTOMATION PROCEDURES', 1;
GO
EXEC SP_CONFIGURE 'XP_CMDSHELL', 0
GO
RECONFIGURE
GO
-- run_value 확인