Gerrit Mantel
Programs MSSQL modules (57 recs)    
NameType descPublishedPub statusDescriptionMinversionGenericAuthorCreatedLastmodifiedUpd statusXp cmdshellOle automationSubprogram cntInfoSourcecode
fun_CreateFolderSQL_SCALAR_FUNCTION2026-01-14Create folder1Gerrit Mantel2020-09-022026-03-07010
fun_date_arraySQL_TABLE_VALUED_FUNCTION2026-01-14Return dates of every given interval on current given period1Gerrit Mantel2015-12-022024-02-09000
fun_date2isoweekSQL_SCALAR_FUNCTION2026-01-14Return the ISO weeknumber for a given date1Gerrit Mantel2004-12-072024-02-09000
fun_date2monthSQL_SCALAR_FUNCTION2026-01-14Return the description of the month for a given date1Gerrit Mantel2004-12-042024-02-09000
fun_date2weekdaySQL_SCALAR_FUNCTION2026-01-14Return the description of the weekday for a given date1Gerrit Mantel2004-12-072024-02-09000
fun_DeleteFileSQL_SCALAR_FUNCTION2026-01-14Delete given file(s)1Gerrit Mantel2017-10-102026-01-23010
fun_DeleteFolderSQL_SCALAR_FUNCTION2026-01-14Delete given folder(s)1Gerrit Mantel2017-10-102026-01-23010
fun_DriveProperty_FreeSpaceSQL_SCALAR_FUNCTION2026-01-14Return the free space in bytes of a given drive1Gerrit Mantel2000-01-012024-02-09010
fun_DriveProperty_TotalSizeSQL_SCALAR_FUNCTION2026-01-14Return the total size in bytes of a given drive1Gerrit Mantel2000-01-012024-02-09010
fun_DriveProperty_VolNameSQL_SCALAR_FUNCTION2026-01-14Return the volume name of a given drive (or remote share)1Gerrit Mantel2000-01-012024-02-09010
fun_FileExistSQL_SCALAR_FUNCTION2026-01-14Check if file exists1Gerrit Mantel2015-11-242026-03-30010
fun_FileProperty_ArchivebitSQL_SCALAR_FUNCTION2026-01-14Return the archive bit of a file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_DateCreatedSQL_SCALAR_FUNCTION2026-01-14Return the date created of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_DateLastModifiedSQL_SCALAR_FUNCTION2026-01-14Return the date created of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_NameSQL_SCALAR_FUNCTION2026-01-14Return the name of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_SizeSQL_SCALAR_FUNCTION2026-01-14Return the size (in bytes) of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FolderExistSQL_SCALAR_FUNCTION2026-01-14Check if folder exists1Gerrit Mantel2015-11-242026-03-30010
fun_FolderProperty_DateCreatedSQL_SCALAR_FUNCTION2026-01-14Return the date created of a given directory name1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_DateLastModifiedSQL_SCALAR_FUNCTION2026-01-14Return the date last modified of a given directory name1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_NameSQL_SCALAR_FUNCTION2026-01-14Return the foldername of a given directory1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_SizeSQL_SCALAR_FUNCTION2026-01-14Return the size (in bytes) of a given directory1Gerrit Mantel2000-01-012024-02-09010
fun_int_arraySQL_TABLE_VALUED_FUNCTION2026-01-14Returns a table with integer values between given minval and maxval1Gerrit Mantel2020-08-272024-02-09000
fun_nsplitSQL_TABLE_VALUED_FUNCTION2026-01-14Split delimited n-string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_nsplit_notrimSQL_TABLE_VALUED_FUNCTION2026-01-14Split delimited n-string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_splitSQL_TABLE_VALUED_FUNCTION2026-01-14Split delimited string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_split_notrimSQL_TABLE_VALUED_FUNCTION2026-01-14Split delimited string into record values (not trimmed)1Gerrit Mantel2024-02-132024-04-09000
fun_TempFolderSQL_SCALAR_FUNCTION2026-03-07Get Windows temp folder directory1Gerrit Mantel2026-03-072026-03-07010
fun_time_arraySQL_TABLE_VALUED_FUNCTION2026-01-14Return time array for a given date with variable interval1Gerrit Mantel2015-12-022024-02-09000
fun_year2easterSQL_SCALAR_FUNCTION2026-01-14Return the date of 1-st easter day of a given year1Gerrit Mantel2004-12-072024-02-09000
prc_backup_databaseSQL_STORED_PROCEDURE2026-03-30Make a full (or differential) database backup for a given database11.01Gerrit Mantel2011-01-172026-04-03002
prc_backup_logSQL_STORED_PROCEDURE2026-03-30Make a transaction log backup for a given database11.01Gerrit Mantel2011-04-282026-04-03002
prc_backup_systemdbSQL_STORED_PROCEDURE2026-05-12NewMake full backup of all system databases1Gerrit Mantel2014-07-292026-05-12Recently modified004
prc_backup_userdb_diffSQL_STORED_PROCEDURE2026-05-12NewMake differential backup of all user databases12.01Gerrit Mantel2014-07-292026-05-15Recently modified004
prc_backup_userdb_fullSQL_STORED_PROCEDURE2026-05-12NewMake full backup of all user databases12.01Gerrit Mantel2014-07-292026-05-12Recently modified004
prc_backup_userdb_logSQL_STORED_PROCEDURE2026-05-12NewMake transaction log backup of all user databases12.01Gerrit Mantel2019-10-292026-05-13Recently modified005
prc_check_database_backupSQL_STORED_PROCEDURE2026-05-12NewCheck database backup state1Gerrit Mantel2026-05-122026-05-14New0011
prc_create_backup_jobsSQL_STORED_PROCEDURE2026-05-12NewCreate jobs for backup- and check backup procedures0Gerrit Mantel2026-05-122026-05-13New003
prc_dump_survive_info_agentSQL_STORED_PROCEDURE2026-04-09Generate sqlserver agent settings text file0Gerrit Mantel2026-04-092026-04-09002
prc_dump_survive_info_dbmailSQL_STORED_PROCEDURE2026-04-09Generate database mail settings text file0Gerrit Mantel2026-04-092026-04-09002
prc_dump_survive_info_sqlserverSQL_STORED_PROCEDURE2026-04-09Generate sqlserver settings text file12.00Gerrit Mantel2026-04-092026-04-09002
prc_dump_survive_scriptSQL_STORED_PROCEDURE2026-04-09Dump scriptfile to create SURVIVE database12.00Gerrit Mantel2026-04-092026-05-12Recently modified001
prc_ps_computersystemSQL_STORED_PROCEDURE2026-01-24List properties of the local Computer System1Gerrit Mantel2026-01-242026-03-07105
prc_ps_diskSQL_STORED_PROCEDURE2026-01-24List properties of the Disks on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_diskpartitionSQL_STORED_PROCEDURE2026-01-24List properties of the Disk Partitions on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_dtcSQL_STORED_PROCEDURE2026-01-24List properties of the DTC on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_dtcnetworksettingSQL_STORED_PROCEDURE2026-01-24List properties of the DTC-Networksetting on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_networkadapterSQL_STORED_PROCEDURE2026-01-24List properties of the Networkadapter on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_networkadaptercfgSQL_STORED_PROCEDURE2026-01-24List properties of the Networkadapter Configuration on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_operatingsystemSQL_STORED_PROCEDURE2026-01-24List properties of the Operating System on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_processorSQL_STORED_PROCEDURE2026-01-24List properties of the Processor of the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_ps_volumeSQL_STORED_PROCEDURE2026-01-24List properties of the Volumes on the local computer1Gerrit Mantel2026-01-242026-03-07105
prc_restore_databaseSQL_STORED_PROCEDURE2026-04-04Restore a database from it's latest backupfiles12.01Gerrit Mantel2011-10-122026-04-10005
prc_save_text_to_fileSQL_STORED_PROCEDURE2026-01-14Write text variable to ansi file1Gerrit Mantel2017-01-252025-06-06010
prc_save_text_to_utf8fileSQL_STORED_PROCEDURE2026-01-14Write text variable to utf-8 file with BOM1Gerrit Mantel2025-10-122025-10-12010
prc_table2csvSQL_STORED_PROCEDURE2026-01-18Generate CSV file for a given table or view14.01Gerrit Mantel2026-01-182026-05-15Recently modified108
prc_table2htmlSQL_STORED_PROCEDURE2026-01-14Generate HTML table for a given table or view14.01Gerrit Mantel2025-11-232026-02-07005
prc_table2insertSQL_STORED_PROCEDURE2026-01-14Generate insert commands for a given table or view14.01Gerrit Mantel2022-12-012026-01-28002