SQL Server Performance

tables with no clustered index

Discussion in 'Contribute Your SQL Server Scripts' started by chopeen, Aug 12, 2004.

  1. chopeen Member

    /*****************************************************************
    * A script checking if there are any tables with no clustered *
    * index *
    * *
    * *
    * ver 1.0 (2004.08.11) *
    *****************************************************************/

    select id, name
    from sysobjects
    where OBJECTPROPERTY(id, N'TableHasClustIndex') = 0
    and OBJECTPROPERTY(id, N'IsUserTable') = 1
    order by name
    chopeen, Aug 12, 2004
    #2

  2. Madhivanan Moderator

    Can you highlight the changes you made?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Feb 12, 2006
    #2

Share This Page