Artem Ervits (@dbist)
April 8, 2011 at 1:43 pm
I need to run a policy and exclude a certain set of servers that have databases that contain heaps. Is there a way to combine more than one facet or condition in a policy?
Right there with Babe
April 8, 2011 at 2:03 pm
Yes. @SQLChicken already replied to this on the #sqlhelp hashtag on Twitter. Create condition for facet TABLE and use property of @HasClusteredIndex = True.
This posting is provided "AS IS" with no warranties, and confers no rights.My Blog: TroubleshootingSQLTwitter: @banerjeeamit
April 8, 2011 at 2:40 pm
thanks I just got it to work also, I was doing it a mad scientist way when I could've just added hasclusterdindex with hascompressedpartitions, thanks for the reply.
April 8, 2011 at 2:41 pm
Here you go, wrote this up for you: Find Heaps Using Policy-Based Management[/url]
=============================================================/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!Follow me on Twitter | Connect on LinkedInMy blog: http://sqlchicken.comMy book: Pro Server 2008 Policy-Based Management
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply