RE: Error 80040e14

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 05:17:30 -0800

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.