메모장

21,20 / 고유설정 포트에도 방화벽으로 인해 외부접근 차단.

방화벽 – 예외 – 프로그램에 windows\system32\inersrv\inetinfo.exe 추가.

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'ygmail',
@recipients = 'yykwon@cyberwin.co.kr',
@subject = 'Automated Success Message',
@body = '메일을 받아라',
@body_format = 'text',
@file_attachments = 'c:\test.txt'

용량 수정하기 

msdb.dbo.sysmail_configure_sp 'MaxFileSize' , 10097152

-- OLE 기능 사용 수정

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

DECLARE
@IMG_PATH VARCHAR(MAX),
@TIMESTAMP VARCHAR(MAX),
@ObjectToken INT,
@FILENAME varbinary(MAX),---new variable here
@hr int
 
 
   SELECT @IMG_PATH = filnm
                    ,@FILENAME = filedata ---column selected here
  FROM syver01t   a
  where  a.filnm  = 'apf01.pbd'
 
  SET @TIMESTAMP = 'd:\sign\'+@IMG_PATH
 
  select @IMG_PATH,@TIMESTAMP,@FILENAME
 
  EXEC @hr = sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT
  select @hr
  EXEC @hr = sp_OASetProperty @ObjectToken, 'Type', 1
  select @hr
  EXEC @hr = sp_OAMethod @ObjectToken, 'Open'
   select @hr
  EXEC @hr = sp_OAMethod @ObjectToken, 'Write', NULL, @FILENAME --new variable here
  select @hr
  EXEC @hr =sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @TIMESTAMP, 2
  select @hr
  EXEC @hr =sp_OAMethod @ObjectToken, 'Close'
  select @hr
  EXEC @hr =sp_OADestroy @ObjectToken
  select @hr