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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 566786 Comments
Status Closed Workarounds
Type Bug Repros 7
Opened 6/11/2010 11:58:12 AM
Access Restriction Public


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.

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.