Gerrit Mantel
Programs SQL_STORED_PROCEDURE - prc_dump_survive_info_dbmail

Main program

Nameprc_dump_survive_info_dbmail
Type_descSQL_STORED_PROCEDURE
CommentSQLServer Stored Procedure

PURPOSE
Generate database mail settings text file.

The script filename name is info_dbmail.txt and is dumped to the give dump_path.
The dump_path must exist and will be checked.

PARAMETERS
- 1 @dump_path VARCHAR(255) Path to dump file survivekit.sql to.

USED OBJECTS

SQLSERVER CONFIGURATION
- OLE Automation has to be enabled.

EXAMPLES
EXEC dbo.prc_dump_survive_info_dbmail @dump_path='C:\Data\MSSQL\survivekit'

HISTORY
2026-04-09 - Created procedure

TAGS
<program>
<description>Generate database mail settings text file</description>
<generic>0</generic>
<author>Gerrit Mantel</author>
<created>2026-04-09</created>
<lastmodified>2026-04-09</lastmodified>
</program>
DescriptionGenerate database mail settings text file
Minversion
Generic0
AuthorGerrit Mantel
Created2026-04-09 00:00:00
Lastmodified2026-04-09 00:00:00
Xp_cmdshell0
Ole_automation0
Subprogram_cnt2
Sourcecode

Sub programs

NameType descDescriptionMinversionGenericAuthorCreatedLastmodifiedXp cmdshellOle automation
fun_FolderExistSQL_SCALAR_FUNCTIONCheck if folder exists1Gerrit Mantel2015-11-24 00:00:002026-03-30 00:00:0001
prc_save_text_to_fileSQL_STORED_PROCEDUREWrite text variable to ansi file1Gerrit Mantel2017-01-25 00:00:002025-06-06 00:00:0001