I am facing a strange issue with Policy Based Management. Exact problem is as below
I have Lenovo laptop having 3 SQL instances installed on it.
SQL Server 2005 (x86) Developer Edition 9.00.4053 -- Named Instance :
SQL Server 2008 (x86) Developer Edition 10.0.1600.22 -- Named Instance :
SQL Server 2008 R2 (x86) Developer Edition 10.50.1600.1 -- Named Instance :
I configured SQL2K8R2 instance as a Centralized Server and registed
SQL2K8 & SQL2K5 under this. I configured a new condition by using facet:
MULTIPART NAME. As per this condition Table Should start with
TEST_ in database TEST . Evaluation Mode set to
On Change: Prevent. Idea is if some one logs to database
TEST and tries to create table with name other then starting with
TEST_ then it should fail.
I Imported this policy on registered servers thru Centralized Management Server Action, as expected policy got configured on Registred
View Complete Post