March 23, 2006 at 5:31 am
Hi
When I try to open tables within SQL 2000 Enterprise Manager by clicking the tables icon, then right clicking a table and selecting Open|Return all rows the table does not open. I get timed out and Enterprise Manager shuts down. The database remains intact! Can I fix this without reinstalling SQL 2000?
March 23, 2006 at 7:28 am
This is probably due to the fact that there is a lot of rows being returned and the query is just timing out. I have never found this method of returning data very good. I would suggest you open a query analyzer window and run a select statement on the tables from there. It's much more reliable and cleaner, plus it will allow you to continue working with EM while your query is running.
March 23, 2006 at 8:27 am
What SP is installed on the server.
from
Killer
March 23, 2006 at 8:29 am
alternatively you could run a query by right clicking on the table ,selecting open table and choosing query.If you are more comfortable with access there comes the point and click query tool
March 24, 2006 at 8:46 am
Service Pack 4, I have an identical set up on another server which works fine.
March 24, 2006 at 8:48 am
Cheers, will give it a go. However, I have an identical set up on another server which works fine.
March 24, 2006 at 11:10 am
It could be a problem with Enterprise Manager. You could reinstall just the client tools. Use the install disk, select install and when it asks you what to install, choose Client Tools Only. Then you will get a list of applications to install. Uncheck everything but Enterprise Manager (it won't uninstall anything).
-SQLBill
March 27, 2006 at 12:07 am
I will try this, cheers.
March 27, 2006 at 4:44 am
Thanks for all your help! I have found out that the IT manager had not installed the SQL service pack!! Can anyone tell me how to close this issue?
March 27, 2006 at 6:22 am
You just closed it. By telling everyone you solved the issue, no one else 'should' respond any more.
-SQLBill
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply