The Ultimate Index Lister (Pivoted)

  • Comments posted to this topic are about the item The Ultimate Index Lister (Pivoted)

  • 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)


    DROP PROCEDURE [dbo].[SP_Name]


    Good utility otherwise,


  • 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.

  • Nice -

    IF OBJECT_ID('dbo.Util_ListIndexes_Columns', 'P') IS NOT NULL


    DROP PROCEDURE dbo.Util_ListIndexes_Columns


    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