SQL Server Home
SSMS: Intellisense breaks when a database is taken offline
6/11/2010 11:58:12 AM
User(s) can reproduce this bug
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.
SQL Server 2008 R2 - Developer Edition
Tools (SSMS, Agent, Profiler, Migration, etc.)
Windows 7 Professional
Operating System Language
Steps to Reproduce
1) Use Intellisense in SSMS 2008 R2.
2) Take a database offline that was online during the last instance restart.
3) Refresh Intellisense's local cache or reconnect to the instance, and try to use Intellisense.
Intellisense stops working for the server instance until the database is brought back online, or the instance is restarted.
Intellisense continues to work without requiring a restart of the instance.
to post a comment.
Please enter a comment.
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.
on 5/18/2011 at 7:38 AM
I can also reproduce this. With SQL Server 2008 and SSMS 2008R2.
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.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft