I installed the ILMerge plugin and recompiled the /src version of MsSqlSpatial. I then deleted my old database and started all over. But when i try to deploy i get this error:
C:\CVS\mssqlspatial.codeplex.com\MsSqlSpatial-2.0>msscmd -deploy -server=localho
st\SQLEXPRESS -db=mssql_test -deploypermission=EXTERNALACCESS
MsSqlSpatial Command Line Tool (Build 0.1.3415.13982)
Copyright © Ricardo Stuven 2006-2007
Deploying to database 'mssql_test' at localhost\SQLEXPRESS:
Dropping assembly dependencies...
Running script 1 of 116...
Running script 2 of 116...
Running script 3 of 116...
Ohanterat undantag: System.ApplicationException: Exception occured executing scr
IF (@@TRANCOUNT > 0)
AND NOT EXISTS (SELECT name FROM sys.assemblies WHERE name=N'MsS
EXEC sp_executesql N'
CREATE ASSEMBLY [MsSqlSpatialLibrary] AUTHORIZATION [public]
WITH PERMISSION_SET = SAFE'
IF (@@ERROR <> 0)
---> System.Data.SqlClient.SqlException: CREATE ASSEMBLY for assembly 'MsSqlSpa
tialLibrary' failed because assembly 'MsSqlSpatialLibrary' failed verification.
Check if the referenced assemblies are up-to-date and trusted (for external_acce
ss or unsafe) to execute in the database. CLR Verifier error messages if any wil
l follow this message
I've tried -undeploy to clean things up but that didnt help. I also tried to deply it as UNSAFE as I did earlier with the 1.7.x version. I think I got the same problem as described in http://mssqlspatial.codeplex.com/Thread/View.aspx?ThreadId=51327