Red Gate forums :: View topic - Error when running "find invalid objects"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Error when running "find invalid objects"

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
georhill



Joined: 27 Jan 2011
Posts: 13

PostPosted: Fri Jun 01, 2012 2:15 am    Post subject: Error when running "find invalid objects" Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Jun 01, 2012 10:19 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group