I am still having this problem - would greatly appreciate if anyone knows what is going on. Is this my SQL installation acting up? I am using SQL 2008 R2.
Basically, anytime I ask the Modeler to create a new database, it produces an error during creation, but still continues. The error is:
Error on executing:
ALTER DATABASE [test] SET READ_COMMITTED_SNAPSHOT ON
The following error occurred: Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
What it tries to do is:
ALTER DATABASE [test] SET READ_COMMITTED_SNAPSHOT ON;
GO
When I try to re-run the application it will no longer work because it never gets past the "Synchronizing Database" stage. I have to use a new database everytime - although sometimes restarting the SQL service and Mendix seems to work (not consistently)
Any pointers?