Unable to show database 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

Unable to show database objects

Postby drizzt001 » Mon Apr 22, 2013 9:40 am

When attempting to refresh suggestions on a SQL Server 2012 instance which has a database in a restoring state (e.g. Database2), even if connected to a different database (Database1), I receive the following message:

SQL Prompt - Unable to show database objects

SQL Prompt cannot retrieve objects from Database1. Possible reasons:

- insufficient memory to cache objects
- invalid permissions for this database
- connection error
- corrupted database


Under the details section is the following:

SQL Prompt could not retrieve all schema information for Database1.

Database 'Database2' cannot be opened. It is in the middle of a restore.


We keep one database in our instance in a permanently restoring state as we are log shipping to it, so this issue affects all other databases on the instance.

This did not occur with SQL Prompt 4 on SQL Server 2005.
drizzt001
 
Posts: 1
Joined: Mon Apr 22, 2013 9:32 am

Postby Anu Deshpande » Tue Apr 23, 2013 11:50 am

Many thanks for your post.

I have logged a support call for you call reference for which is F0072088.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests