Undocumented Extended Procedures 1

[gbraden]

Hi everyone,

I spent the last two days going through a long list, looking about for descriptions of undocumented SP/XP procedures (USP). I managed to find rudamentry descriptions for about 85%. This is for a security plan required by my organization.

If anyone uses any of the following USPs and can respond with a brief description for any, I would very much appreciate it. I know that some I can guess at. Please don't make too much an effort. All were looked up on Google (Bing doesn't give back much in return). Thanks in advance.

sp_AddFunctionalUnitToComponent
sp_createorphan
sp_droporphans
sp_enable_sql_debug
sp_execute
sp_fetchLOBfromcookie
sp_fstr_getlocalnameforwinfs
sp_fstr_onfileclose
sp_fstr_onfileopen
sp_fulltext_freelist
sp_fulltext_getdata
sp_PostAgentInfo
sp_prepexecrpc
sp_replddlparser
sp_replhelp
sp_replsendtoqueue
sp_replsetsyncstatus
sp_replwritetovarbin
sp_resyncexecute
sp_resyncexecutesql
sp_resyncprepare
sp_resyncuniquetable
sp_SetOBDCertificate
sp_setuserbylogin
sp_update_user_instance
xp_adsirequest
xp_cleanupwebtask
xp_convertwebtask
xp_MSADEnabled
xp_MSADSIObjReg
xp_MSADSIObjRegDB
xp_MSADSIReg
xp_msx_enlist
xp_passAgentInfo
xp_prop_oledb_provider
xp_replposteor
xp_sqlagent_enum_jobs
xp_sqlagent_is_starting
xp_sqlagent_notify
xp_sqlagent_param
xp_sysmail_activate
xp_sysmail_attachment_load
xp_sysmail_format_query


Glen Braden

 

[markros]

Nice list for George's blog:

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/identify-procedures-that-call-sql-server