| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-09-17 : 09:21:54
|
| Hello ,I have just copied data from SQL Server 7.0 TO SQL Server 2000 Std. Edition SP 2 . But the enterprise manager in SQL 2000 does not show correct results of the tables , for e.g in terms of rows . But it shows correctly in the SQL query analyzer . Is this a know problem on SQL 2000 ? How can we resolve this . Will dbcc updateusage help in this case ?? Any ideas ??Thanks. |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-09-17 : 09:51:41
|
| When you say EM doesn't give the correct results, what do you mean ? Have you refreshed the EM view? Are you firing an EM query ? |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-09-17 : 09:56:13
|
| Hi Wanderer ,I mean when i open the EM then select the database and open it with taskpad , then after selecting the tableinfo from the top of the taskpad menu , there the results are not displayed correctly . Any thoughts to it ??Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-17 : 10:06:46
|
quote:
Any thoughts to it ??
Ummmmmm, well, considering...quote:
But it shows correctly in the SQL query analyzer
Maybe you should ONLY use query analyzer for displaying data?EM was never designed to be a full-fledged data-entry/query tool, and it should not be used for that purpose. If QA is too unwieldly for you or others to use, it's very easy to link tables in an MS Access database and use Access' query tools. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-17 : 13:10:43
|
| Run DBCC UPDATEUSAGE ('databasename') WITH NO_INFOMSGS in QA for the database in question and then have another look at taskpad.HTHJasper Smith |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-09-18 : 05:33:30
|
| Given what Rob says - don't use EM as a data mining tool etc.Having said that, what is the point of EM having a funciton that doesn't work ...Are you certain that the EM data is incorrect, or incorrectly displayed ? Have you tried Jaspers point ?What info are you looking for, specifically ?ciao |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-09-18 : 11:25:51
|
| Although i didn't try to run the bdcc updateusage command , but i guess it should solve the issue as i thought and first wrote in my very first post that DBCC updateusage might help in this case , but was not sure. But the point is we have to run BDCC updateusage without which the EM shows incorrect results , even if you try to refresh many times or even close the EM and start again . But i will run the DBCC and check again . Is this problem known to Microsoft ???Thanks for all your replies and support. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-18 : 12:34:47
|
quote:
Is this problem known to Microsoft ???
It could be that they know about it, but again, you're expecting too much from EM. It has always been intended strictly as an admin tool. You should not rely on it for data functions, now or ever. That's why Query Analyzer is available.You CAN hammer a nail with a screwdriver, but why use it if you already have a hammer?Edited by - robvolk on 09/18/2002 12:35:30 |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-09-18 : 12:37:22
|
| As I hope is indicated in my last post - I agree with you. It is all good and well to say that this isn't the purpose of EM, but don't put it in if it is broken/doesn't work. The work-around, if correct, is disturbing in the fact that it needs to be run.I don't know if this is a known bug ( assuming it truly is a bug, as it appears to be). Check out the bug fix list for SP2 etc. ... I'll see if I find it anywhere.Edited by - wanderer on 09/18/2002 12:38:04 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 12:47:18
|
| Does it report 0 rows?-Chad |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-18 : 16:30:44
|
Its not a bug, the rowcnt/rows value for sysindexes are not always updated immediately and can be come innacurate - this is documented as is the DBCC UPDATEUSAGE command. You can use Profiler to trace the SQL statement that Taskpad runs to generate the display ( I won't post it because its LOOOOONG ) but you'll see that it uses sysindexes.rows for the row count. If you have to know accurately how many rows you have in a table then select count(*) is the way to go.HTHJasper Smith |
|
|
|
|
Is there a bug in SQL 2000 EM ???