﻿DECLARE @sql nvarchar(max)='' 

SELECT @sql += 'DROP PROCEDURE [' + ROUTINE_SCHEMA + '].[' + ROUTINE_NAME + '];
' FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME='sp_GetTermek'

EXEC sp_executesql @sql