Posted by Erland Sommarskog on 02/18/07 10:37

DanWeaver (danofweaver@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]