The Ultimate Index Lister (Pivoted)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jesse Roberge » The Ultimate Index Lister (Pivoted)

The Ultimate Index Lister (Pivoted)

Rate Topic

Display Mode

Topic Options

Author

Message

YeshuaAgapao

Posted Monday, August 04, 2008 1:27 PM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701, Visits: 207

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

Post #546337

Douglas Osborne-456728

Posted Thursday, October 09, 2008 6:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327

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

Post #583241

YeshuaAgapao

Posted Thursday, October 09, 2008 12:08 PM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701, Visits: 207

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.

Post #583524

Douglas Osborne-456728

Posted Thursday, October 09, 2008 1:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327

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 Wink

Post #583568

« Prev Topic | Next Topic »

Permissions