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?
Thanks
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.
Reference: http://msdn.microsoft.com/en-us/library/ms135681
This posting is provided "AS IS" with no warranties, and confers no rights.
My Blog: TroubleshootingSQL
Twitter: @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 LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply