Full error: Error 1 The reverse engineering operation cannot continue because you do not have View Definition permission on the 'xxxx' database. 0 0.
Description: Once i was comparing sql schema using SqlSchemaComarre in Visual studio 2013 i got same error. Every thing seems to be right but i was stuck with the problem. Suddenly i go through the user permission an i saw in User Mapping for selected database db_owner was unchecked. I check the same and that worked for me.
Solution: GO TO
Hope it would work for you to. :-)
Description: Once i was comparing sql schema using SqlSchemaComarre in Visual studio 2013 i got same error. Every thing seems to be right but i was stuck with the problem. Suddenly i go through the user permission an i saw in User Mapping for selected database db_owner was unchecked. I check the same and that worked for me.
Solution: GO TO
- SQL server management studio
- Security
- Logins
- Specific user
- properties
- User mapping
- Specific database
- Check db_owner
- ok
Hope it would work for you to. :-)