Error when running "find invalid objects"

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Error when running "find invalid objects"

Postby georhill » Fri Jun 01, 2012 2:15 am

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 5.3.2.2).

"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.
georhill
 
Posts: 13
Joined: Thu Jan 27, 2011 8:31 pm

Postby Brian Donahue » Fri Jun 01, 2012 10:19 am

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.
Brian Donahue
 
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