There is a bug in the SQL Server 2008 June CTP that causes Declarative Management to be inoperable. The fix is very simple. Launch a command line and run the following command:
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe -Vr Microsoft.SqlServer.DmfSqlClrWrapper,89845DCD8080CC91
After running the command you will need to restart the SQL Server service.
The Declarative Management DLL, which runs inside the SQLCLR, did not get signed as part of the build process. Running the above command will disable strong name verification for this assembly. Client-side checking of policies: "Test Policy" and "Run Now" will function as expected without the fix. Policy automation (enforce, check on change, and check on schedule), though, will require applying the above fix.
89845DCD8080CC91 ... Aha! So simple. If only I got the last 3 digits correctly!
I've long been anticipating the Declarative Management Framework (DMF, not to be confused with dynamic
I've been looking at the June CTP build for a few days now. Only a small number of the promised features