Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Ultimate Index Lister (Pivoted) Expand / Collapse
Author
Message
Posted Monday, August 04, 2008 1:27 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
Comments posted to this topic are about the item The Ultimate Index Lister (Pivoted)


Post #546337
Posted Thursday, October 09, 2008 6:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, October 09, 2008 12:08 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
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
Posted Thursday, October 09, 2008 1:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Post #583568
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse