Provides intelligent code completion for SQL Server editors.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law
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 9:32 am
Many thanks for your post.
I have logged a support call for you call reference for which is F0072088.
- 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