Monday, December 26, 2011

SSMS Cache

The Microsoft SQL Server Management Studio is the Visual Studio for DB guys, with SQL Server 2008 R2, the IntelliSense feature in SSMS is awesome.  It saves time and the experience is cool.  Some time the IntelliSense will not work.  There can be several reason for this. 

  • You may be typing multiple statements with out proper batch separation (GO). 
  • The underlying schema is changed.

If it is schema change you can try refreshing the Cache, must of the time it helps.


No comments:

Post a Comment

TSql Script out data

In SQL Server Management Studio (SSMS) you can generate script out the DB Object, you can also generate script for data (Insert statements...