Mathew Nolton BlogSoftware dementia unleashed...SqlScript for dropping a set of procedures, user-defined functions or views- May 25, 2006 I have been wanting to write some posts lately of some productivity tools and tricks. My last post was for a VS-Addin for updating the reference paths for all "selected" projects in your visual solution set. This post is for a sql script that enables you to drop a series of stored procedures, UDF's or Views. I thought about adding tables but then I would have to handle keysconstraints as well....maybe next time. PRINT N'Dropping proceduresfunctions...' GO PRINT...http://weblogs.asp.net/mnolton/archive/2006/05/25/SqlScript-for-dropping-a-set-of-procedur... Add-In for updating all reference paths in a solution- May 25, 2006 Update Project References Add-In Visual Studio doesn't natively support the ability to update all selected project's within a Solution with the same reference paths. This is important (at least to me) if you have to download from your source control system a different version of your source code. Since you typically do not check in your project preferences into source control, you will be stuck with the mundane task of selecting your project, setting the reference path, select the next...http://weblogs.asp.net/mnolton/archive/2006/05/25/Add-In-for-updating-all-reference-paths-... |