Showing incorrectly that objects are invalid
meklembl
Posts: 107 Bronze 2
Within SSMS 2008, SQL Prompt is showing that objects, including the database, are invalid objects even when SSMS shows at the top and bottom of the screen that I am in that database and the query runs.
This does not occur on all my servers, but I do have permissions to run SELECT statements on all my servers.
This does not occur on all my servers, but I do have permissions to run SELECT statements on all my servers.
Larry M
Cleveland, OH USA
Cleveland, OH USA
Comments
SQL Prompt requires a few more permissions for Find Invalid Objects to work correctly:
- Select
- Execute
- View Definition
- Set ShowPlan
- Set NoExec
- Create Trigger
- Create Procedure
- Create View
- Create Function
Please let me know if this helps! If you have any more questions let me know.Best regards,
David
I am the DBA for the organization. I am the sysadm on all our database servers. I will look at the permissions at a more granular level, but as a beta tester for your product, I knew most of what you stated. I would not have posted this if I thought something else wasn't going on.
Larry
Cleveland, OH USA
I think I may have misunderstood your post! There's a feature in SQL Prompt called Find Invalid Objects.
Are you saying that you're writing a select statement in the query window, but Prompt is not providing suggestions for you?
Are these newly created objects (created while you've had SSMS open)? If so, have you used Refresh Suggestions in the Prompt menu?
Best regards,
David
Sorry for the slow response,
Cleveland, OH USA
Would it be possible to have a remote session with you so we can see this issue in action?
Best regards,
David
Today from 3:00 - 4:00 PM EDT
Tomorrow most of the day.
Thurs. 1:00-4:00 PM EDT
Friday 9:00-11:30 AM EDT
Cleveland, OH USA
Would it be OK to do it early tomorrow morning for you? Let me know when we can start and I'll send over a meeting invite.
Best regards,
David
Cleveland, OH USA
Cleveland, OH USA
It seems a little inconsistent, but I didn't dig real deep and my trial has expired. So I can't really duplicate. Just and FYI and something to look at.
I'm one of the developers on SQL Prompt. I had a call with Larry a couple of weeks back and it looked like the problem was unlikely to us.
How are the objects coming up as invalid? Through "Find Invalid Objects" or in the query window? If they are being underlined in red in the query window, that is SSMS's behaviour.
If you see the collation issues again, please let us know!
Best regards,
David