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 PK-Less / CLIDX-Less Table Finder Expand / Collapse
Author
Message
Posted Thursday, November 6, 2008 12:07 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 PK-Less / CLIDX-Less Table Finder


Post #598446
Posted Friday, December 5, 2008 8:07 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,

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

Doug
Post #614577
Posted Friday, December 5, 2008 11:27 AM


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
No I wanted to output tables that was missing one or the other or both, not just both. HasPrimarykey+HasClusteredIndex is in the order by so tables missing both will sort to the top. Then tables missing only PKs, then tables missing only clustered indexes.


Post #614845
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse