Cannot Describe and Object, VIEW DATATBASE STATE Permission Denied in Database
Posted: Fri 01 Feb 2019 16:48
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?
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?