enterprise manager error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sql server 2000 enterprise manager - 17 Aug 2005 21:23 GMT

Hi,
When trying to modify or add a table using enterprise manager I got this
message error:
Enterprise manager: not enough storage is available to complete this
operation.

I have a lot off space available.
I don't have a memory leake.
My server is Dell PowerEdge 2850 with tho CPU ( 3.6 GHZ)
I Regestred my SQL server 2000 on another enterprise manager in a second
server and I was able to modify the table.
I was able to create a table by using query analyser.
Could someone help me find the bug?

Reply to this Message

Andrew J. Kelly - 18 Aug 2005 03:02 GMT

Using EM to modify live tables is never a good idea. It often will create a
new table, copy all the rows over to the new table and then drop the old
one. So it must have at least as much space available in the db as the
table being modified and its indexes. But that does not explain why EM
worked on the other machine.

Signature

Andrew J. Kelly SQL MVP

> Hi,
> When trying to modify or add a table using enterprise manager I got this
[quoted text clipped - 9 lines]
> I was able to create a table by using query analyser.
> Could someone help me find the bug?

Reply to this Message

sql server 2000 enterprise manager - 18 Aug 2005 15:16 GMT

Hi, Andrew,
I beleive that using Enterprise manager is not the best choice. but my
issue occurs even when I try to modify a small database as northwind or pubs.

> Using EM to modify live tables is never a good idea. It often will create a
> new table, copy all the rows over to the new table and then drop the old
[quoted text clipped - 15 lines]
> > I was able to create a table by using query analyser.
> > Could someone help me find the bug?

Reply to this Message

Andrew J. Kelly - 18 Aug 2005 23:08 GMT

Sounds like a client issue then. Haven't seen that before. You can try
reinstalling the client tools but I bet it is an issue with that machine
more than EM.

Signature

Andrew J. Kelly SQL MVP

> Hi, Andrew,
> I beleive that using Enterprise manager is not the best choice. but my
[quoted text clipped - 23 lines]
>> > I was able to create a table by using query analyser.
>> > Could someone help me find the bug?

Reply to this Message