--删除数据库发布后，发现还有很多相关的proc存在， 手动清除下！

 

 

SELECT  'drop proc dbo.'+name  FROM sys.procedures

WHERE name LIKE 'sp_MSupd_%' UNION ALL SELECT 'drop proc dbo.'+name FROM sys.procedures WHERE name LIKE 'sp_MSdel_%' UNION ALL SELECT 'drop proc dbo.'+name FROM sys.procedures WHERE name LIKE 'sp_MSins_%' go