January 13, 2010 at 7:33 am
Hi,
How do I get the intellisense for the new database when I change the database in the query window using "USE [DatabaseName]". somehow it still has the old database's objects. I tried refreshing cache but no luck. If I type [DatabaseName].dbo.[MyTable] it works but I don't want to do that for all queries. Please let me know if there is a way to update the intellisense.
Thanks,
sridhar.
January 13, 2010 at 9:18 am
Try the cache refresh, CTL-SHIFT-R
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 13, 2010 at 9:30 am
I already tried it but it didn't work.
March 29, 2010 at 1:51 am
It should work. Try to change the correct database name on the drop down [More left corner in Management studio] and then follow this process.
http://praveenbattula.blogspot.com/2010/01/refresh-intellisense-local-cache-in-sql.html
March 29, 2010 at 6:54 am
If you are sure that you're properly refreshing the cache, then you may be hitting a bug. All the tests I've run show it working just fine, so I'm not sure what else to say here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply