뷰, 펑션등을 수정할때마다 쏘스를 저장하는 방법
CREATE TABLE dbo.SPLOG(일련번호 int IDENTITY(1,1) NOT NULL,오브젝트명 varchar(100) NULL,구분 varchar(20) NULL,SQLCMD varchar(max) NULL,수정자 varchar(20) NULL,수정일 datetime NULL, CONSTRAINT XPKSPLOG PRIMARY KEY NONCLUSTERED (일련번호 ASC)) GO CREATE TRIGGER TRG_SPLOG ON DATABASEFORCREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE,CREATE_VIEW, ALTER_VIEW, DROP_VIEW,CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION,CRE..