Re: enterprise manager error

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:92AC93CE-7CAD-4F79-A92C-1B2B0B08B3CD@xxxxxxxxxxxxxxxx
> 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?


.

Relevant Pages

  • Re: enterprise manager error
    ... reinstalling the client tools but I bet it is an issue with that machine ... > I beleive that using Enterprise manager is not the best choice. ... >> Using EM to modify live tables is never a good idea. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: enterprise manager error
    ... I beleive that using Enterprise manager is not the best choice. ... issue occurs even when I try to modify a small database as northwind or pubs. ... "Andrew J. Kelly" wrote: ... >> I Regestred my SQL server 2000 on another enterprise manager in a second ...
    (microsoft.public.sqlserver.clients)
  • enterprise manager error
    ... When trying to modify or add a table using enterprise manager I got this ... not enough storage is available to complete this ... I Regestred my SQL server 2000 on another enterprise manager in a second ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Proxy Agent and cmdExec
    ... You can modify the SQL Agent, Job object in Enterprise manager, but my ...
    (microsoft.public.sqlserver.programming)
  • Disallow changes to underlying user tables
    ... I am attempting to secure my SQL Server 2000 databases. ... to modify "existing" stored procedures but NOT the underlying table schemas ... you to modify existing tables... ...
    (microsoft.public.sqlserver.programming)