|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
"Not enough Storage"When I tried to save a stored proedure (in SQL Server 2005 Express), I got an
error saying "The operation could not be completed. Not enough storage is available to complete this operation." Any idea what is causing this error to pop up? I still have about 4GB disk space left. Thanks. SQL Express has a 4GB limit on the database size so if you're at that limit
you are out of space no matter how much disk space is left. -- Show quoteThis posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Swami" <Sw***@discussions.microsoft.com> wrote in message news:E6536E4F-31BE-4609-9DFC-FFCC5C6A1CD2@microsoft.com... > When I tried to save a stored proedure (in SQL Server 2005 Express), I got > an > error saying "The operation could not be completed. Not enough storage is > available to complete this operation." > > Any idea what is causing this error to pop up? I still have about 4GB > disk > space left. > > Thanks. My whole MSSQL folder is only 148 MB and my particular database in question
is only 2MB in size. I actually have very little data...about 7-8 tables which are mostly empty and about 25 stored procedures, each of them quite short. Any ideas? Thanks. Show quote "Roger Wolter[MSFT]" wrote: > SQL Express has a 4GB limit on the database size so if you're at that limit > you are out of space no matter how much disk space is left. > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > > "Swami" <Sw***@discussions.microsoft.com> wrote in message > news:E6536E4F-31BE-4609-9DFC-FFCC5C6A1CD2@microsoft.com... > > When I tried to save a stored proedure (in SQL Server 2005 Express), I got > > an > > error saying "The operation could not be completed. Not enough storage is > > available to complete this operation." > > > > Any idea what is causing this error to pop up? I still have about 4GB > > disk > > space left. > > > > Thanks. > > > Well, one guess is you might have choosen the option
Do not autogrow right click on database -> properties -> datafiles check - Automatically grow file. and also maximum file size -> unrestricted file growth. Do the same in log files. And see. Hope this helps. And I believe this is your test database. (and not production :) You may want to check out this link too.
http://support.microsoft.com/default.aspx?scid=kb;en-us;166840&sd=tech What tool are you using to create the stored procedure? You might try
saving the proc script to a file and creating with the SQLCMD.EXE command-line utility. -- Show quoteHope this helps. Dan Guzman SQL Server MVP "Swami" <Sw***@discussions.microsoft.com> wrote in message news:E6536E4F-31BE-4609-9DFC-FFCC5C6A1CD2@microsoft.com... > When I tried to save a stored proedure (in SQL Server 2005 Express), I got > an > error saying "The operation could not be completed. Not enough storage is > available to complete this operation." > > Any idea what is causing this error to pop up? I still have about 4GB > disk > space left. > > Thanks. this message indicated a bug referenced in sql server 2000 if you are using
lookups... try your error message with google Nicolas Guinet "Swami" <Sw***@discussions.microsoft.com> a écrit dans le message de news: E6536E4F-31BE-4609-9DFC-FFCC5C6A1***@microsoft.com...Show quote > When I tried to save a stored proedure (in SQL Server 2005 Express), I got > an > error saying "The operation could not be completed. Not enough storage is > available to complete this operation." > > Any idea what is causing this error to pop up? I still have about 4GB > disk > space left. > > Thanks.  |
|||||||||||||||||||||||
Other interesting topics