Unable to show database objects

Provides intelligent code completion for SQL Server editors.

Unable to show database objects

Postby drizzt001 » Mon Apr 22, 2013 8: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.
Posts: 1
Joined: Mon Apr 22, 2013 8:32 am

Postby Anu Deshpande » Tue Apr 23, 2013 10: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: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests