Gail,

I'm pretty sure you haven't answered my question.

The question is, not is it necessary to have the primary key specified in indexes, but is it redundant?

Doug

Gail,

Ok - so those indexes which have the PK attached to them are fine if they end up being covering indexes?

Doug

Gail,

Ok - I'm looking at our system.

It seems as though the people before me included the base PK column in the rest of their indexes.

So I'D see a PK of...

Gail,

I have a simple index question I cannot Google an answer on.

If I have a table MyData with a PK of MyDataID, should I ever have an index the has...

Nice script.

Might this

'CREATE NONCLUSTERED INDEX IX__' + parentschemas.name + '_' + parentobjects.name + '__' + REPLACE(foreign_key_columns.foreign_key_columns, ', ', '_') + ' ON ' + parentschemas.name + '.' + parentobjects.name...

I agree - any time I see a CURSOR declaration in the first few lines of code...

Jacob,

I cannot find that link - did it move?

Best,

Doug

Or

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

BEGIN

DROP PROCEDURE [dbo].[SPName]

END

Tom,

Saying everyone is wrong really doesn't help us solve this. 🙂

Give us an example of your solution please.

Doug

David,

Missed that in your text. My bad.:D

Couldn't you double parse by writing all the text you encounter prior to -- to a temp table and then process that?

Ah - but...

Carlo,

I altered th SP - your routine still only lists a dependent SP, it lists not tables. SQL 2005.

Doug

Carlo,

No go with that call - it still only show an SP that my Stored Procedure calls, not any tables.

It says the oType is 16, if that is any help.

Doug

David,

What I think happens it that you code finds a word in the comments that is a valid table in the database eg

-- Patients is linked to the Accounts table

Where...

David,

Perhaps I need to clarify - it listed a table the SP does not use at all.

Best,

Doug

Carlo,

Your code did not list ANY tables in the SP, but it did list another SP called from within it?

Are either yours or David's routines dependent upon ownership in the...