I have developed a web application using Entity Framework Code First and can't use the SQL Server database. Whenever my app tries to interact with it I get "A trigger returned a resultset and the server option 'disallow results from triggers' is true. ". What can I do? I believe the database connection is the right one, the major difference between my local test environment and the deployment server is that I'm using SQL Server Compact CE 4.
Tried to Sql Server Compact CE 4 but keep getting "access is denied" errors. How do I get my database to work??
Managed to get it working by installing SQL Express locally, creating the database there with Code First and publishing it to Winhost's SQL server.