I get the following error when I right-click on some of our databases (SQL Server 2008 R2 64-bit) and select "find invalid objects" (SQL Prompt 126.96.36.199).
"You have insufficient permissions to find invalid objects in EbusPPROD.
Your user must have the VIEW DEFINITION permission granted on the database to find invalid objects."
The database log in I am using has sysadmin role so I question that it is a permissions issue as stated in the error message.
For the database above, SQL Prompt says it is checking 1000 objects. Is that too many? It's not a huge database, at least size-wise.
A couple of other databases in the same instance have 5 objects and 38 objects and "find invalid objects" completes successfully and says it did not find any invalid objects.
Thanks for any input.