How could I correct the erroneous value on the property window of an SQL Table.
My problem is that, if I am going to display the property window of Table1, the 'Rows' information displays 115. However, if I am going to execute - Select Count(*) from Table1 then it returns 117. How could I fix this glitch?
Also, Enterprise Manager checks the state of various databases and database objects when it first starts up, or when they are first selected. It won't reflect changes to the database made since the initial check unless you refresh the Enterprise Manager view.
If it's not practically useful, then it's practically useless.