An underused feature of SQL Server
Extended stored procedures are a useful way to display information about files or your system. Extended stored procedures let you execute noninteractive DLLs from a stored procedure or an Interactive SQL (ISQL) window. SQL Server Books Online (BOL) documents about 90 extended stored procedures in SQL Server 7.0 and 20 in 6.5. More than 145 documented and 50 undocumented extended stored procedures ship with SQL Server. For a list of all stored procedures, run
EXEC sp_helpextendedproc
Some o...