Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)为什么我的没有智能提示???是不是因为是Express Edition ???谢谢!!
会不会是你用SQL 2008的UI去链接SQL 2005或者2000了?那样的话是没有智能提示的
http://social.msdn.microsoft.com/Forums/ar/sqltools/thread/dcd5c2cb-fc53-4c28-8b09-bfd9fea6684e Hello all! I had the same issue, that intellisense did not work on SQL Server 2008 R2.On my system the reason for this behaviour was a database which was switched offline.When i switched all databases online, intellisense worked (after i refreshed the local cache).To test it, i switched one database offline again, and after i refreshed the local cache intellisense didn't work again.Perhaps this helps others to solve the problem.Silent_R
Hello all! I had the same issue, that intellisense did not work on SQL Server 2008 R2.On my system the reason for this behaviour was a database which was switched offline.When i switched all databases online, intellisense worked (after i refreshed the local cache).To test it, i switched one database offline again, and after i refreshed the local cache intellisense didn't work again.Perhaps this helps others to solve the problem.Silent_R
我也碰到这个问题,装了SQL SERVER 2008补丁还不好,是因为VS2010 SP1装上了的原因,真是气人!
Print @@version
1、如果你是连接当前的实例,而且当前实例是MSSQL2008及以上的数据库版本。 这就杯具了。2、如果是连接其他实例,查看其他实例是否是MSSQL2008及以上版本,如果不是,OK,正常。
如果需要用它,怎么办?升级其他实例的版本至2008(up on)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)为什么我的没有智能提示???是不是因为是Express Edition ???谢谢!!
Hello all!
I had the same issue, that intellisense did not work on SQL Server 2008 R2.On my system the reason for this behaviour was a database which was switched offline.When i switched all databases online, intellisense worked (after i refreshed the local cache).To test it, i switched one database offline again, and after i refreshed the local cache intellisense didn't work again.Perhaps this helps others to solve the problem.Silent_R
I had the same issue, that intellisense did not work on SQL Server 2008 R2.On my system the reason for this behaviour was a database which was switched offline.When i switched all databases online, intellisense worked (after i refreshed the local cache).To test it, i switched one database offline again, and after i refreshed the local cache intellisense didn't work again.Perhaps this helps others to solve the problem.Silent_R