Re: Error 80040e14

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 15:03:33 +0100

There are circumstances where autogrow doesn't seem to grow fast enough, which mean that you still
get the error. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M.L." <ML@discussions.microsoft.com> wrote in message
news:4AAEAC7A-372D-40A7-9676-78EF18C91131@microsoft.com...
> Hi Mike,
>
> Thanks for your answer! I have checked the disk, and there is plenty of
> space left on the drive.
>
> In the Enterprise Manager, I can see that the database file properties
> (right-click on db --> properties --> Data Files) already are set to
> "Automatically grow file" and "Unlimited file growth". Was that what you
> meant by expanding the DB? Why does the error appear when the DB apparently
> is allowed to grow indefinetely? And what can I do?
>
> Thanks, your help is greatly appreciated!
>
> regards,
>
> /M.L.
>
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > The error "Could not allocate space for object
> > '_cc_SkuDump' in database 'CDS' because the 'PRIMARY' filegroup is full.) "
> > indicates that your database CDS does not have enough space left to continue
> > the Insert.
> >
> > Expand the database though Enteprise Manager.
> >
> > Regards
> >
> > "M.L." wrote:
> >
> > > Hi NG,
> > >
> > > I hope very much someone can help me or at least point me in the right
> > > direction here. I have a simple Stored Procedure and all it does is it adds 4
> > > different indexes to a rather large table which is built daily. It has been
> > > running for 6 months now without problems, but today I found this error
> > > message in the log:
> > >
> > > ---- error message from log-file-------begin
> > >
> > > Step 'DTSStep_DTSExecuteSQLTask_1' failed
> > >
> > > Step Error Source: Microsoft OLE DB Provider for SQL Server
> > > Step Error Description:The statement has been terminated. (Microsoft OLE DB
> > > Provider for SQL Server (80040e14): Could not allocate space for object
> > > '_cc_SkuDump' in database 'CDS' because the 'PRIMARY' filegroup is full.)
> > > (Microsoft OLE DB Provider for SQL Server (80040e14): Warning! The maximum
> > > key length is 900 bytes. The index 'cluster_SkuDump' has maximum length of
> > > 2765 bytes. For some combination of large values, the insert/update operation
> > > will fail.)
> > > Step Error code: 80040E14
> > > Step Error Help File:
> > > Step Error Help Context ID:0
> > >
> > > ---- error message from log-file-------end
> > >
> > > So what is wrong and how can I remedy it? Thanks a lot in advance!
> > >
> > > /M.L.

Relevant Pages

  • Re: Error 823
    ... Regards. ... Microsoft SQL Server Storage Engine ... > I cannot extract much data out of the database and I can't view the most ... The problem is in the .MDF file, ...
    (microsoft.public.sqlserver.tools)
  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: error 80020009 HELP!!!
    ... Check your SQL Server event logs for any problems. ... Mike Epprecht, Microsoft SQL Server MVP ... > when they try to access the database through a web browser. ... > info by performing a database restore? ...
    (microsoft.public.sqlserver.server)
  • Re: View Security
    ... SQL Server MVP ... Columnist, SQL Server Professional ... The user can see list of other users who can login into the database. ... able to see all database structue such as view/table/sp definitions. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I Allow SQL DB dump job through a firewall?
    ... I'll try to setup a process that grabs the database on a regular basis after ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)