enterprise manager error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: User Defined Data Types Problem
    ... The storage size is 4 bytes. ... Since you mention Enterprise Manager, I assume that you use SQL 2000. ... You cannot use int as a base, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • 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)
  • 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: SQL Proxy Agent and cmdExec
    ... You can modify the SQL Agent, Job object in Enterprise manager, but my ...
    (microsoft.public.sqlserver.programming)