Finding orphaned SPs and UDFs in SQL Server

Two approaches to finding orphaned stored procedures and user-defined functions in your database. 1) a simple C# .NET tool that uses SQL Server Management Objects (SMO), and 2) a SQL script that checks sys.sql_dependencies.