Gerrit Mantel
 |
Programs | SQL_STORED_PROCEDURE - prc_dump_survive_info_sqlserver |  |
 |
 |
 |
| Name | prc_dump_survive_info_sqlserver |
| Type_desc | SQL_STORED_PROCEDURE |
| Comment | SQLServer Stored Procedure PURPOSE Generate sqlserver settings text file. The text filename name is info_sqlserver.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 to. USED OBJECTS - master.sys.server_principals - master.sys.dm_server_services - master.sys.dm_os_sys_info - master.sys.dm_os_memory_clerks - master.sys.configurations - master.sys.master_files - master.sys.databases - master.sys.dm_os_memory_nodes - master.sys.dm_os_nodes - xp_readerrorlog (undocumented extended procedure) - xp_instance_regread (undocumented extended procedure) SQLSERVER CONFIGURATION - OLE Automation has to be enabled. EXAMPLES EXEC dbo.prc_dump_survive_info_sqlserver @dump_path='C:\Data\MSSQL\survivekit' HISTORY 2026-04-09 - Created procedure TAGS <program> <description>Generate sqlserver settings text file</description> <generic>0</generic> <minversion>12</minversion> <author>Gerrit Mantel</author> <created>2026-04-09</created> <lastmodified>2026-04-09</lastmodified> </program> |
| Description | Generate sqlserver settings text file |
| Minversion | 12.0 |
| Generic | 0 |
| Author | Gerrit Mantel |
| Created | 2026-04-09 00:00:00 |
| Lastmodified | 2026-04-09 00:00:00 |
| Xp_cmdshell | 0 |
| Ole_automation | 0 |
| Subprogram_cnt | 2 |
| Sourcecode |  |
| Name | Type desc | Description | Minversion | Generic | Author | Created | Lastmodified | Xp cmdshell | Ole automation |
|---|---|---|---|---|---|---|---|---|---|
| fun_FolderExist | SQL_SCALAR_FUNCTION | Check if folder exists | 1 | Gerrit Mantel | 2015-11-24 00:00:00 | 2026-03-30 00:00:00 | 0 | 1 | |
| prc_save_text_to_file | SQL_STORED_PROCEDURE | Write text variable to ansi file | 1 | Gerrit Mantel | 2017-01-25 00:00:00 | 2025-06-06 00:00:00 | 0 | 1 |