SQL 2008

I have a couple of questions about SSMS which I've been unable to find the
answers for and I'm hoping someone can help.

1 - When I create a new object, SSMS intellisense doesn't know about that
object until I close it and restart it. Is there a way to "refresh" it so
intellisense knows about these new objects? I've tried hitting "refresh" at
the server level but that doesn't help.

2 - a frustration with intellisense is that it's not context sensitive, and
probably that I don't know exactly how to use it properly. Suppose I'm
typing the following: where PayrollDate between '12/1/2009' and
'12/31/2009'. What intellisense does when I start typing the 'and' is it
finds my name - Andre - because there's a schema named Andre. That's not
what I want of course so I finish typing 'and' and then hit a space. Of
course, doing that means intellisense finishes the word and I'm left with
Andre instead of 'and'. Which means I end up hitting backspace a few times
and grumbling. I say it's not context sensitive because obviously if I'm
using "between", I can only want 1 thing between my 2 values - AND. In this
case it's not really "intelli". Is there any way to get this to work
without always selecting Andre, short of turning it off, or is this an
enhancement MS will need to make?

Thanks, Andre

Andre
1) ctrl-shift-R
2) There are many frustrations with intellisense unfortunately

"Andre" <no (AT) spam (DOT) com> wrote

Thanks. I guess we'll take the good with the bad, and hope they improve the
next version. Kinda sounds like every MS product eh?

Andre