I am doing a Schema Compare. If the source and target are Windows Authentication, the Schema Compare runs. But if one of the compared schemas is SQL Server Authentication, I am able to run through the compare wizard but the compare finishes with the error:
Issue only with SQL Server Authentication Users that do not have rights to VIEW DEFINITION.
WORKAROUND: Run the following to give access to VIEW DEFINITION
GRANT VIEW ANY DEFINITION TO PUBLIC
This issue might only affect SQL Server Authentication Users for SQL Server 2005.