April 2008 - Posts

• How to drop all tables, all views, and all stored procedures from a SQL 2005 DB...

  This 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.   create procedure usp_DropSPFunctionsViews as   -- variable to object Read More... Posted Tuesday, April 29, 2008 4:00 PM by Patrick Gallucci | 2 Comments Filed under: sql server 2005, SQL Function, SQL Script, SQL Server Stored Procedure