Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marekchmel
Starting Member
2 Posts |
 Posted - 2008-07-04 : 07:18:04
|
| Hi folks,i was wonderign .. is there a way how to find out in which facet is a searched property through some SELECT from a dmv maybe?Eg. in which facet is a property ClrEnabled (its in surface area config) but through some queryThx,Marek |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-04 : 13:34:35
|
| You can't enable it with DMV.You have to use SP_Configure to enable it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 18:18:16
|
| No, you can't enable policy management with sp_configure. Only doable in gui as I know. |
|
|
|
marekchmel
Starting Member
2 Posts |
Posted - 2008-07-05 : 02:56:12
|
| I was not talking about enable/disable policy management, but searching for properties in facets through queries |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 22:33:03
|
| You can query views with name like syspolicy_* in msdb, books online tells you. |
|
|
|
|
|
|
Policy management through queries