David,

Weird stuff with your code - it prints out a table NOT in the SP.

Also, it DOES print tables from another DB - could this be because they are in...

Jesse,

Shouldn't (HasPrimarykey=0 OR HasClusteredIndex=0) be

(HasPrimarykey=0 AND HasClusteredIndex=0) ?

Doug

Tim,

Why use LIKE if you are not adding % - shouldn't you just say = instead then?

Doug

Hey,

This didn't work for me until I added a % at the end of the first dynamic SQL statement:

SELECT @sql = CASE

WHEN

Jesse,

I lost the link to this topic - do you have the URL of your script?

Thanx,

Doug

Jesse,

Nice change to the program.

Doug

YeshuaAgapao ,

Good Deal - did you fix my mistake - count( index_id) As Indicies should be (COUNT( index_id ) - 1 ) As Indicies.

Best,

Doug

Jesse,

Another great article.

You could make one little add to this - return the number of Indicies for the table by adding

COUNT( index_id ) As Indicies,

to your inner join where you...

Adam,

He had it on his site - #18

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

GO

CREATE FUNCTION dbo.udf_SQL_DataTypeString (

@BaseDataType nvarchar(128) -- base name like int,...

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 😉

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

You'd have to ask the contractor.

Doug

The whole package was about $15k - which included hauling out the old system, the oil tank, reworking the ducts, hiring a drill to drill 480ft down and hooking everything...

Grant and Steve,

I switched my heating and cooling over to geothermal about 5 years ago - I have already paid back my investment! Besides heating and cooling my house, I...