Missing index script? 1

[icemel]

Hi,

Does anyone have a script for detecting missing indexes on all tables for a given database?

Thanks much

 

[gmmastros]

That's like asking for a script that shows threads with missing stars. How do you know there's supposed to be a star if it's missing.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

SELECT
sysobjects.name as TableName
FROM
sysobjects
WHERE
type = 'U'
AND OBJECTPROPERTY(sysobjects.id , 'TableHasIndex' ) = 0

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[icemel]

Thank you SQLDenis, I knew there was a way to do this