SET NOCOUNT ON

DECLARE @objName varchar(80)
DECLARE @objType char(2)
DECLARE cur CURSOR FOR	
SELECT name, type
FROM SYSOBJECTS 
WHERE 	(	
		(type = 'P' AND (name LIKE 'usp[_]%' OR name like 'isp[_]%'))
		OR
		(type = 'FN' AND name LIKE 'udf[_]%')
		OR
		(type = 'TF' AND name LIKE 'udf[_]%')
		OR
		(type = 'U')
		OR
		(type = 'V' AND name LIKE 'v[_]%')
		OR
		(type = 'TR')
	)
	AND 
		uid = 1
	AND
		status > -1

OPEN cur 
FETCH NEXT FROM cur 
INTO @objName, @objType

WHILE @@FETCH_STATUS = 0
BEGIN
	IF @objType IN ('TF', 'FN')
		EXEC ('DROP FUNCTION dbo.' + @objName)

	IF @objType = 'P'
		EXEC ('DROP PROC dbo.' + @objName)

	IF @objType = 'V'
		EXEC ('DROP VIEW dbo.' + @objName)

	IF @objType = 'TR'
		EXEC ('DROP TRIGGER dbo.' + @objName)

	FETCH NEXT FROM cur 
	INTO @objName, @objType
END

CLOSE cur 
DEALLOCATE cur 

GO