InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:35:26 GMT20http://www.sqlservercentral.com/Forums/Topic546337-1320-1.aspxNice - IF OBJECT_ID('dbo.Util_ListIndexes_Columns', 'P') IS NOT NULLBEGIN DROP PROCEDURE dbo.Util_ListIndexes_ColumnsENDis a bit more compact ;-)Thu, 09 Oct 2008 13:07:43 GMTDouglas Osborne-456728http://www.sqlservercentral.com/Forums/Topic546337-1320-1.aspxI submitted a fix for the existance check. The 'U' should be 'P'. Several other of my submissions had the same issue and I submitted fixes for them also.Thu, 09 Oct 2008 12:08:50 GMTYeshuaAgapaohttp://www.sqlservercentral.com/Forums/Topic546337-1320-1.aspxJesse,That script is not rerunnable - try this for your existence check.IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[SP_Name]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)BEGIN DROP PROCEDURE [dbo].[SP_Name]ENDGood utility otherwise,DougThu, 09 Oct 2008 06:18:15 GMTDouglas Osborne-456728http://www.sqlservercentral.com/Forums/Topic546337-1320-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Index+Management/63931/">The Ultimate Index Lister (Pivoted)</A>[/B]Mon, 04 Aug 2008 13:27:07 GMTYeshuaAgapao