ASP: Constraints and triggers problem in visual studio
I detached my databa开发者_Go百科se from sql server and dragged and dropped in into visual studio in the App_data folder. Created a new connection to this database, tested it, everything works fine.
The problem is I created a set of constraints and triggers back in sql server management studio. When I open the tables in visual studio, no constraints neither triggers appear. This problem is affecting my web application by not storing values neither perform custom defined formulas.
Is there any solution for this ?
Check this out for express features: http://msdn.microsoft.com/en-us/library/ms165636.aspx
Was the original instance a SQL Server Express server that you attached to? This list does support triggers, but doesn't mention constraints. Also, you have to use the query optimizer, so I think that means there is no direct option in SQL Server to see it, but you could work with it via the optimizer or scripting.
HTH.
精彩评论