Welcome to SSQA.net Sign in | Join | Help

SQL Server 2008 (SSQA.net)

Trusted, Productive and Intelligent enterprise data platform.
SQL Server 2008 June CTP Declarative Management Bug
The new feature in SQL 2008 that is Declarative Management has a bug and it seems to be inoperable. Dan Jones from MSFT has suggested the fix is to 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 for that instance.

This is due to 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.

Also you can find the updated online readme for SQL Server 2008 June CTP here.

 

Posted: Sunday, June 10, 2007 4:15 PM by SQL Master
Filed under: , , ,

Comments

SSQA - SqlServer-QA.net said:

The new feature in SQL 2008 that is Declarative Management has a bug and it seems to be inoperable. Dan

# June 10, 2007 5:51 PM

MOCKALb's BLOG said:

Возьмем простую задачу: необходимо запретить все имена таблиц, которые начинаются на Test. Для этого

# June 20, 2007 5:45 AM
Anonymous comments are disabled