SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


an unexpected error happened during this operation. (MS Design Tools) - Not enough storage is...


an unexpected error happened during this operation. (MS Design Tools) - Not enough storage is available to complete this operation

Author
Message
marianna arossa
marianna arossa
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 3

i have a problem with sql server enterprise manager: whenever i try to return all the rows of a table, by means of the option menu, it returns the following error message: an unexpected error happened during this operation. (MS Design Tools) - Not enough storage is available to complete this operation.

I have sql server enterprise edition with sp3 installed.

When I run the same query (that returns me all the rows belonging to a table) by sql Query Analyzer everything is ok.

Can anyone help me finding the problem with my Sql Enterprise Manager?

Thank you Marianna




AJ Ahrens
AJ Ahrens
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16662 Visits: 9

You may not have enough memory on your PC to do this.

What happens when you try and do this via QA ?





Good Hunting!

AJ Ahrens


webmaster@kritter.net
marianna arossa
marianna arossa
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 3

When i do it via QA it works fine, it returns me all the rows belonging to the table without any error message.

I tryed to access the server via remote desktop and also in this case I had no problem both via option menu and via QA. The server has 2GB of RAM.

In the end i would like to add that no error is registered in the event viewer neither in SQL Server error file.

Thank you Marianna


AJ Ahrens
AJ Ahrens
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16662 Visits: 9
I don't think the problem is with your server rather your PC itself. I think you are overrunning your own memory buffer..



Good Hunting!

AJ Ahrens


webmaster@kritter.net
kevin tall
kevin tall
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1

I have exactly the same symtoms. I have rebuilt the server twice using Windows 2K SP4 and SCL 2000 SP3, but as soon as I use Enterprise Manager to view a table the "Not enought Storage..." message appears.

Have you managed to find the problem yet? It looks like I may have to return the server (under warrenty) unless someone can advise on a fix.

Kevin Tall


ND-215452
ND-215452
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1835 Visits: 2

I think AJ is right, EM is not a good place a view all rows of a table especially a large one. It consumes alot of mem.

That is why there is QA


Brian-247838
Brian-247838
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1

I have one server running SQL Server SP 2 and one running SP 3. The SP 3 box has the error and the SP 2 box does not. I don't know if this is causal or coincidental yet. But I know that the databases are exactly the same and the SP 3 box is much, much more powerful.

More specifically, when the SP 3 box connects to the SP 2 box, though Enterprise Manager, it generates the error. When the SP 2 box connects to the SP 3 box, it does not.

So it seems to be a problem with the Enterprise Manager GUI and not the underlying DBMS.

Brian


Jeff Benedict
Jeff Benedict
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1
We too have pretty much the same issue. We have clustered Dell PowerEdge 2850 servers w/ 4GB Ram, connecting to a CX300 SAN. We get the message on all 4 servers whether or not they connect to a database on the SAN or on another stand alone server. We can run EM from some other non-clustered server and it works fine. We've tried reinstalling SQL, and even rebuild one of the 2-node clusters from the ground up using different media. This did not work. We have escalated this problem to Dell and Microsoft. Any update to this would be appreciated. I will update this link if I get an answer.
Preston Peterson
Preston Peterson
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 1
I also have the same problems described. New Dell PE2800 with 4GB of RAM running Windows 2000 w/ SP4 and SQL 2000 W/ SP3a. Try to return rows from EM on the test Northwinds db and get the same error. It doesn't matter the database.
Jeff Benedict
Jeff Benedict
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1

I have created a case w/ Microsoft thru Dell about this issue. They want me to boot one of my clustered servers into VGA mode and try the same process on a non-clustered database. Unfortunately, my units are in production and to bring one of them down to "test a theory" is not feasable anytime soon. Can one of you who are having this issue, that may not be in production yet, try booting in VGA mode and seeing what happens. Microsoft seems to believe that it may be a corrupted VIDEO driver causing the issue. Our servers were built from the Dell Factory and all we did was load SQL on them and cluster them. So if it's a driver corruption, it's happening during the SQL install, or SP update or a bad driver from Dell.

Please post if anyone can do this.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search