Re: Error 80040e14
From: M.L. (ML_at_discussions.microsoft.com)
Date: 11/25/04
- Next message: Uri Dimant: "Re: Get List of Table names in database"
- Previous message: David Portas: "Re: Get List of Table names in database"
- In reply to: Tibor Karaszi: "Re: Error 80040e14"
- Next in thread: Tibor Karaszi: "Re: Error 80040e14"
- Reply: Tibor Karaszi: "Re: Error 80040e14"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Nov 2004 06:15:03 -0800
Hi,
Ok?! Interesting.. Well, I am looking in the right place then? (Data File
tab in EM)
Should I manually allocate a large portion of space then? Would that be a
solution?
Thanks!
Regards,
M.L.
"Tibor Karaszi" wrote:
> 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.
>
>
>
- Next message: Uri Dimant: "Re: Get List of Table names in database"
- Previous message: David Portas: "Re: Get List of Table names in database"
- In reply to: Tibor Karaszi: "Re: Error 80040e14"
- Next in thread: Tibor Karaszi: "Re: Error 80040e14"
- Reply: Tibor Karaszi: "Re: Error 80040e14"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
