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

• Next in forum: Re: count records in several months
• Prev in forum: Re: count records in several months
• Thread view: Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?

[Reply to this message]