Version: 12.0.9-3
Build #: 30310
Build Date: 2012-Nov-24 10:50:49 AM

ALLOW_ROW_LOCKS=OFF and ALLOW_PAGE_LOCKS=OFF should not be the default for a new SQL Server ER Model Constraint

1. Open attached ER Model

2. Expand the table node , so that you see the node constraints

3. Right Click on Constraints tree node and create a new Primary Key constraint.

4. You can see that the contraint is created with (ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF) which is incorrect.  These should follow the same rules as the ADS Visual GUI's.

If you use ADS GUI to create a constraint you can look at the Preview SQL to see the DDL and you will see that the allow_row_locks and allow_page_locks clause are not included, and thus delegating the default to SQL Server.

5. Fix for  New Unique Constraint as well.