enterprise manager error

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?
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.
Andrew J. Kelly SQL MVP
"sql server 2000 enterprise manager" <sql server 2000 enterprise
manager@.discussions.microsoft.com> wrote in message
news:92AC93CE-7CAD-4F79-A92C-1B2B0B08B3CD@.microsoft.com...
> 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?
|||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.
"Andrew J. Kelly" wrote:

> 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.
> --
> Andrew J. Kelly SQL MVP
>
> "sql server 2000 enterprise manager" <sql server 2000 enterprise
> manager@.discussions.microsoft.com> wrote in message
> news:92AC93CE-7CAD-4F79-A92C-1B2B0B08B3CD@.microsoft.com...
>
>
|||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.
Andrew J. Kelly SQL MVP
"sql server 2000 enterprise manager"
<sqlserver2000enterprisemanager@.discussions.micros oft.com> wrote in message
news:24AD6EC4-3A53-4D5A-90A2-8F6633C4A5AC@.microsoft.com...[vbcol=seagreen]
> 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.
> "Andrew J. Kelly" wrote: