SQL Server Performance Forum – Threads Archive
SQL Server issues
Hello,We are running SQL server 2000 on our dedicated web server. I am new to sql server; had problems with error ‘Not Enough Storage available to complete this operation’ when i open table design. (it doesnt show the extended properties on field in bottom section) Also i see in disk tray (on left bottom corner), Server icon blinking at regular interval. There is also ignorance on the server side when i performance backup task or other task. nothing happens during that action. any help with this would be highly appreciated. thanks
Hi,
I think this is a memory issue.
check the paging file disk or install additional memory in your system.
It can also be SQL Service Pack issue.
Have your system installed with latest Service pack with many Fixes.
Check this
http://www.dbforums.com/showthread.php?p=3604722#post3604722
Do not attempt to open the table from Enterprise Manger and you must use Query Analyzer by using a query in order to get rows for the tables. For further assessment capture PERFMON counters. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi,
i think you are running out of the disk space ! check if your hdd is full ! free up some space to achieve your things… and do your task using QA as you can hold more control using QA then EM.
Regards
hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
BTW what are the memory settings on SQL Server? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Unfortunately, I cannot view properties of any objects. As soon as i click it, it flashes and nothing happens. when i open the table in design mode it does say not enough storage for the operation. so it must be memory thing. we have i think 256 mb ram. i do have about 77 gb of hd free.
Agree with Satya about Query Analyzer.
But if you fill better with Enterprise Manager, use it from other PC no from Server.
With 256Mb, is memory thing.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
hi,
quote:Originally posted by npathak
Unfortunately, I cannot view properties of any objects. As soon as i click it, it flashes and nothing happens.
when i open the table in design mode it does say not enough storage for the operation. so it must be memory thing.
we have i think 256 mb ram. i do have about 77 gb of hd free.
if you have 77 gb of hd free you can increase your pagefile.sys size to get room / swap to execute the instance , BTW are you facing same problem in any other application tooo ! if is it so then definately its a memory problem … and more over you can refer error log / event viewer for more information in this regards it will give you real picture about an error message…
regards hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
Do not attempt to open such large values using Enterprise Manager, it is always suggested to use Query Analayzer and use ALTER TABLE or ALTER DATABASE statements to accomplish the task. Books online is the best resource about these statement. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>