Extended stored procedures in SQL Server

--List all OLE DB-provided programs installed on the server
Execute Master: Xp_enum_oledb_providers

--Get Hard disk file information
--Parameter Description: directory name, directory depth, whether to display files (less)
--execute Master. Xp_dirtree ' C: '
--execute Master. Xp_dirtree ' C: ', 1
--execute Master. Xp_dirtree ' C: ',

--Lists the list of SQL Server error logs and the last update time
Execute Master: Xp_enumerrorlogs

--List all Windows local groups on the server
Execute Master: Xp_enumgroups

--List The fixed drives on the server and the available space per drive
Execute Master: Xp_fixeddrives

--Get the computer name of the current SQL Server server
Execute Master: Xp_getnetname

--Get the version number of MS SQL
Execute Master: Sp_msgetversion

--List the specific contents of the current error log
EXEC [Master]. [dbo]. [Xp_readerrorlog]

---List the name of the drive
--free space in bytes
--To drive type: Floppy drive (1), HDD (2), CD-ROM (8)
EXEC [Master]. [dbo]. [Xp_availablemedia]

Extended stored procedures in SQL Server