http://blogs.msdn.com/patrickgallucci/archive/2008/04/29/how-to-drop-all-tables-all-views-and-all-stored-procedures-from-a-sql-2005-db.aspxThis is a follow-up to the blog entry from Jasper Jugan . This is a modification to the script to allow for schema specific deletes of the SP's, Views and I added Functions. &#160; create procedure usp_DropSPFunctionsViews as &#160; -- variable to objecten-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/patrickgallucci/archive/2008/04/29/how-to-drop-all-tables-all-views-and-all-stored-procedures-from-a-sql-2005-db.aspx#8439391Wed, 30 Apr 2008 00:24:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:8439391Microsoft news and tips &raquo; How to drop all tables, all views, and all stored procedures from a SQL 2005 DB&#8230;<p>PingBack from <a rel="nofollow" target="_new" href="http://microsoftnews.askpcdoc.com/sql-server-2005/how-to-drop-all-tables-all-views-and-all-stored-procedures-from-a-sql-2005-db">http://microsoftnews.askpcdoc.com/sql-server-2005/how-to-drop-all-tables-all-views-and-all-stored-procedures-from-a-sql-2005-db</a></p> http://blogs.msdn.com/patrickgallucci/archive/2008/04/29/how-to-drop-all-tables-all-views-and-all-stored-procedures-from-a-sql-2005-db.aspx#8536232Fri, 23 May 2008 06:26:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:8536232Smallfootprints Tech Blog<p>One of the problems I had when setting up Community Server 2008 was that my attempts to move from a local</p>