xp_ prefix
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