Home Dashboard Directory Help
Search

SSMS: Intellisense breaks when a database is taken offline by Joel Searcy


Status: 

Closed
 as Fixed Help for as Fixed


15
0
Sign in
to vote
Type: Bug
ID: 566786
Opened: 6/11/2010 11:58:12 AM
Access Restriction: Public
0
Workaround(s)
view
7
User(s) can reproduce this bug

Description

Taking a database offline on a SQL Server 2008 or 2008 R2 instance will break intellisense for all databases on the instance when using SSMS 2008 R2 once the local cache is refreshed (either explicitly or through a new connection).

This only has an affect when taking a database offline that was online when the instance was last restarted. After a restart with the database offline, intellisense works again as expected.

This does not affect intellisense when using SSMS 2008.


Details
Sign in to post a comment.
Posted by Microsoft on 6/28/2011 at 12:06 PM
Thanks for your input. This issue will be fixed in the next major release of SQL Server.

Posted by Ben Demes on 5/18/2011 at 7:38 AM
I can also reproduce this. With SQL Server 2008 and SSMS 2008R2.
Posted by YoullNeverKnow on 10/21/2010 at 9:54 AM
I'm able to reproduce this on SQL Server 2008R2 with CU 3, and also on SQL Server 2008 with SP1 CU 8.
Sign in to post a workaround.