Provides intelligent code completion for SQL Server editors.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law
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 22.214.171.124).
"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.
- Posts: 13
- Joined: Thu Jan 27, 2011 8:31 pm
Thanks for your question - I have been looking into a similar situation with Prompt earlier in the week - Prompt checks for invalid objects using the execution plan for every object, so it's unlikely you will see a match between select count(*) from sysobjects and the number of objects reported by Prompt.
It also has the capability to go through linked servers, so it is possible that Prompt is trying to check an object on the other side of a linked server.
Hopefully this helps.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Prompt 5
Who is online
Users browsing this forum: No registered users and 0 guests