Posted by DanWeaver on 02/19/07 01:23

On Feb 18, 5:37 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> DanWeaver (danofwea...@googlemail.com) writes:
> > In SQL Server Mngmt Express- Object explorer- right click on Databases
> > or any DB or any table.
>
> I suspected that. I'm afraid that's a misunderstanding on your part.
> Refresh there only freshes the list of tables or objects that is
> displayed in the Object Explorer. (Keep in mind that a table has dependent
> object, such as indexes, constraints etc.) It does not affect what you may
> see in other windows.
>
> The way to update the grid in Open Table is simply to press the Exclamation
> mark which reruns the query that loaded the grid. (And which you can see
> by right-clicking and select SQL under the Pane submenu.)
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


You're a star, Erland.
Dan

• Next in forum: query
• Prev in forum: Re: sum a table within a table
• Thread view: Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?

[Reply to this message]