Devart Forums

Hello, I am trying to compare 2 databases that I have read write access to.
using Data Compare for SQL Server.

I do not have Admin rights to the database in question, but I can connect in SSMS, see all the tables, and I have read write to the data itself. I cannot modify table structure. but I am only wanting to compare data.

Any Idea what I am missing?
Thanks
-John

Cannot describe an object. VIEW DATABASE STATE permission denied in database 'AppDB'. The user does not have permission to perform this action.
Do you want to continue describing?

Hello,

Thanks for the post.
We're investigating the problem and answer you as soon as any result is available.

Best Regards.

Thank you! looking forward to it.

-John

Hello,

Sorry for the delay with the answer.
We failed to reproduce the problem at our environment. So, we need a bit more information:
- SQL Server version
- SSMS version
- Data Compare for SQL Server version

Looking forward to your reply.

The error "VIEW DATABASE STATE permission denied" pops up when referencing dynamic administrative view sys.dm_db_xtp_hash_index_stats. To reference this view, you need a permission VIEW DATABASE STATE https://docs.microsoft.com/en-us/sql/re ... erver-2017

In Studio, there is an extended information on the object. This causes the error.