--AJ: Variable for the assembly we want to targetDECLARE @AssemblyName nvarchar(512)--AJ: Set the value for testing purposesSET @AssemblyName = ''--AJ: Declare our cursor--AJ: We just want the rows to read and at full pelt!DECLARE crs_CLRStoredProcs CURSOR FAST_FORWARD read_only FOR ( --AJ: Define the rows we want SELECT sys.procedures.name FROM sys.procedures, sys.assembly_modules, sys.assemblies WHERE sys.procedures.type = 'PC' and sys.procedures.object_id = sys.assembly_modules.object_id and sys.assembly_modules.assembly_id = sys.assemblies.assembly_id and sys.assemblies.clr_name like @AssemblyName )OPEN crs_CLRStoredProcs--AJ: For retriving the stroed proc namesDECLARE @StoredProcName nvarchar(256)--AJ: Retrive the stroed proc namesFETCH NEXT FROM crs_CLRStoredProcs INTO @StoredProcName--AJ: Make sure theres no errorsWHILE @@fetch_status = 0 BEGIN PRINT 'DROP PROCEDURE ' + @StoredProcName END