August 4, 2008 at 1:27 pm
Comments posted to this topic are about the item The Ultimate Index Lister (Pivoted)
October 9, 2008 at 6:18 am
Jesse,
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]
END
Good utility otherwise,
Doug
October 9, 2008 at 12:08 pm
I 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.
October 9, 2008 at 1:07 pm
Nice -
IF OBJECT_ID('dbo.Util_ListIndexes_Columns', 'P') IS NOT NULL
BEGIN
DROP PROCEDURE dbo.Util_ListIndexes_Columns
END
is a bit more compact 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply