Upgraded to V6, now 'cannot retrieve objects' error

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Upgraded to V6, now 'cannot retrieve objects' error

Postby davideedle » Thu Nov 07, 2013 3:27 am

I upgraded to V6 a few days ago, and now I'm plagued with errors: 'SQL Prompt cannot retrieve objects from [database name]'.

It's trying to access databases on the same SQL server, but for which my currently logged in user does not have permission.

This is a definite change since the upgrade.

I looked for an option that might disable this, but could not find it.

How can I tell SQL Prompt not to access databases other than the one I am logged in to (along with master etc)?

It's very annoying. Such a great product otherwise....

David
davideedle
 
Posts: 2
Joined: Thu Nov 07, 2013 3:23 am
Location: Australia

Postby Aaron Law » Thu Nov 07, 2013 10:25 am

Hi David,
I'm sorry that Prompt is causing you problems. We released a new build of prompt yesterday (6.1.0.88) which might contain a fix. Could you give it a go and let me know if it fixes the issue for you?

Thanks,
Aaron.
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby davideedle » Thu Nov 07, 2013 7:19 pm

Hi Aaron

I just downloaded and installed 6.1, so far have not had the problem.

Hopefully that fixed it.

Appreciate the prompt response.

David
davideedle
 
Posts: 2
Joined: Thu Nov 07, 2013 3:23 am
Location: Australia


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest