Refresh item does not update the "number of rows" item in the Object Explorer (4333266)

Refresh item does not update the "number of rows" item in the Object Explorer

The "number of rows" is not updated when selecting "Refresh item" in the Object Explorer.
To recreate the problem please follow the steps below:


1) create a table.For example:

CREATE TABLE [dbo].[test_refresh] (
[Column_1] int NULL,
[Column_2] int NULL)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);
GO
ALTER TABLE [dbo].[test_refresh] SET (LOCK_ESCALATION = TABLE);
GO

2)Select the table in the Object Explorer(the row count will show 0)

3)insert one row
INSERT INTO dbo.test_refresh(
   Column_1
  ,Column_2
) VALUES (
   1
  ,1
)

(autocommit is on)

3) select the table in the Object Explorer , r-click and select "Refresh Item". The row cont is set to 0 instead of to 1.


Tested in the commercial version and in the last beta.6.6.0.291

WORKAROUND

Restart Toad

STATUS

Waiting for fix in a future release of Toad for SQL Server

TSS-705