Date:         Wed, 28 Oct 2009 14:16:15 -0400
Reply-To:     Joe Whitehurst <joewhitehurst@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Whitehurst <joewhitehurst@GMAIL.COM>
Subject:      SAS Related SQL Server 2008 Question
Content-Type: text/plain; charset=ISO-8859-1

SAS-Lers,

I have a data warehouse implemented via a SQL Server 2008 database that I am
in the process of moving to SAS/SPDS where I expect significantly better
query performance.  I'm also preparing a SPDS Table to support some work I
will be doing with Eminer 6.1 as well as forecasting with the SAS Time
Series Forecasting Application.  Here is my problem.  One of the very large
tables in the SQL Server 2008 database was not populated with data after I
spent 12+ hours downloading the database.  However, all the tables necessary
to create the needed table are populated and I have written a query to
create the needed table, but I get the following error messages:

Msg 1105, Level 17, State 2, Line 3
Could not allocate space for object
'dbo.AGGR_WEEK_STORE_CATEGORY_SALES'.'PK_AGGR_WEEK_STORE_CATEGORY_SALES' in
database 'STAGEDW' because the 'PRIMARY' filegroup is full. Create disk
space by deleting unneeded files, dropping objects in the filegroup, adding
additional files to the filegroup, or setting autogrowth on for existing
files in the filegroup.


The only acceptable option is to set "autogrowth on for existing files in
the filegroup".  I cannot be out of space because I have 2.5 Terabytes
available so I know it is an internal SQL Server 2008 issue.  So, how do I
set AUTOGROWTH on in SQL Server 2008?

Joe