출처 :&nbsp;<a href="http://www.sqler.com/491522" target="_blank" class="tx-link">http://www.sqler.com/491522</a> 아래 sql을 해당 데이터베이스에 실행한 후&nbsp;나중에 변경 이력을 볼 수 있다.&nbsp; 글자수가 약 4만자 정도 되면 그 뒤로 짤리는 문제가 있다.<div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">프로시저 문자열 수 체크SELECT A.type, A.NAME, b.definition, len(b.definition) as lens

FROM dbo.SysObjects A LEFT OUTER JOIN sys.sql_modules B ON A.ID = B.object_id

order by
lens&nbsp; desc</div> <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">USE DATABASENAMEGO-- 프로시저 로그용 테이블CREATE TABLE
dbo.SPLOG(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 일련번호 int IDENTITY(1,1) NOT NULL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 오브젝트명 varchar(100) NULL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 구분 varchar(20) NULL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLCMD varchar(max) NULL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 수정자 varchar(20) NULL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 수정일 datetime NULL,&nbsp;CONSTRAINT
XPKSPLOG PRIMARY KEY
NONCLUSTERED (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 일련번호 ASC))&nbsp;GO-- 데이터베이스 트리거CREATE TRIGGER
TRG_SPLOG ON DATABASEFORCREATE_PROCEDURE, ALTER_PROCEDURE,
DROP_PROCEDURE,CREATE_VIEW, ALTER_VIEW,
DROP_VIEW,CREATE_FUNCTION, ALTER_FUNCTION,
DROP_FUNCTION,CREATE_TRIGGER, ALTER_TRIGGER,
DROP_TRIGGER&nbsp;AS&nbsp;DECLARE @DATA XML&nbsp;SET @DATA = EVENTDATA()&nbsp;INSERT INTO
DBO.SPLOG (오브젝트명, 구분, SQLCMD, 수정자, 수정일)VALUES(@DATA.value('(/EVENT_INSTANCE/ObjectName)[1]', 'VARCHAR(100)'),&nbsp;@DATA.value('(/EVENT_INSTANCE/EventType)[1]', 'VARCHAR(100)'),&nbsp;@DATA.value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]', 'VARCHAR(MAX)'),&nbsp;HOST_NAME(),&nbsp;GETDATE())









































































&nbsp;</div>

저장프로시저 변경 이력(history)관리(버전관리)