April 2012
1 post
Script out Database Mail settings
Run this to script out your Database Mail settings so you can copy them to another instance:
USE msdb;
GO
DECLARE
@SQLText VARCHAR(MAX),
@CrLf CHAR(2) = CHAR(13) + CHAR(10);
SELECT @SQLText = '
EXEC msdb.dbo.sp_configure
@configname = ''show advanced options'',
@configvalue = 1;
RECONFIGURE;
EXEC msdb.dbo.sp_configure
@configname = ''Database Mail XPs'',
@configvalue =...
