SQL Server 2000 Stored Procedures Handbook (Experts Voice)

extended stored procedures, 136

system stored procedures, 136

XP_AvailableMedia system stored procedure

code for using, 161

file system stored procedures, 161

TINYINT parameter, 161

XP_CmdShell system stored procedure, 148

XP_DirTree system stored procedure

code for using, 162

file system stored procedures, 162

XP_FileExists system stored procedure

code for using, 163

file system stored procedures, 163

OUTPUT parameter, 163

XP_FixedDrives system stored procedure

code for using, 163

file system stored procedures, 163

XP_Instance_Reg extended stored procedures

Windows registry system stored procedures, 160

XP_LoginInfo system stored procedure, 149

XP_MSVer system stored procedure, 147

XP_ReadErrorLog system stored procedure

code for using, 165

file system stored procedures, 164

parameters, 164

syntax, 164

XP_RegAddMultiString system stored procedure

code for using, 159

guidelines for using, 159

limited usage, 159

Windows registry system stored procedures, 158

XP_RegDeleteKey system stored procedure

care in using, 157

code for using, 157

Windows registry system stored procedures, 157

XP_RegDeleteValue system stored procedure

code for using, 158

guidelines for using, 158

Windows registry system stored procedures, 158

XP_RegEnumKeys system stored procedure

code for using, 156

Windows registry system stored procedures, 156

XP_RegEnumValues system stored procedure

code for using, 157

guidelines for using, 157

Windows registry system stored procedures, 157

XP_RegRead system stored procedure

code for using, 154

guidelines for using, 155

Windows registry system stored procedures, 153

XP_RegRemoveMultiString system stored procedure

code for using, 159

guidelines for using, 159

Windows registry system stored procedures, 159

XP_RegWrite system stored procedure

code for using, 155

guidelines for using, 156

Windows registry system stored procedures, 155

XP_SendMail system stored procedure, 148

bullet-proofing XP_SendMail, 172

XP_Test_Mapi_Profile system stored procedure, 172

compared to XP_SMTP_SendMail stored procedure, 173

recursion, 170

SQL Mail, 169

XP_SMTP_SendMail stored procedure

compared to XP_SendMail system stored procedure, 173

implementing, 172

SQL Mail, 172

wrapper script, 173

XP_SubDirs system stored procedure

code for using, 162

file system stored procedures, 162

XP_Test_Mapi_Profile system stored procedure

bullet-proofing XP_SendMail, 172

NVARCHAR parameter, 172

XP_Trace system stored procedures, 150

tracing object creation and deletion, 169