Re: enterprise manager error

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

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@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: Corrupted Record
    ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> Enterprise Manager to freeze and I have to bring up ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Enterprise Manager
    ... Thank You Andrew, ... >patches if there are any for the client. ... >> I've recently installed SQL Server 7.0 Enterprise ... >> The only piece installed was Enterprise Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: enterprise manager error
    ... Using EM to modify live tables is never a good idea. ... > When trying to modify or add a table using enterprise manager I got this ... > I Regestred my SQL server 2000 on another enterprise manager in a second ...
    (microsoft.public.sqlserver.clients)
  • Re: locks
    ... Andrew J. Kelly wrote: ... > That is handled automatically by SQL Server. ... The transaction would ... > not be ATOMIC if it allowed two users to modify the same row at the ...
    (microsoft.public.sqlserver.programming)
  • 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)