Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raysefo
Constraint Violating Yak Guru
260 Posts |
 Posted - 2006-06-30 : 10:15:35
|
| Hi,i got this error, "could not allocate space for ... in database... because PRIMARY filegroup is full." when i tried to create a table then insert some data approx. 400000 rows with a SP. Here is the code segment of SPSELECT @SQL = 'Create Table [Raw].dbo.[TEST1]('SELECT @SQL = @SQL + '[xID] [int] IDENTITY (1, 1) NOT NULL ,[fTime] [datetime] NOT NULL , [fID] [int] NULL , [fName] [nvarchar] (50) COLLATE Turkish_CI_AS NULL , [bid] [real] NULL , [ask] [real] NULL , [high] [real] NULL , [low] [real] NULL , [bidTrend] [int] NULL , [askTrend] [int] NULL , CONSTRAINT [PK_TEST1] PRIMARY KEY CLUSTERED ( [xID], [fTime] ) ON [PRIMARY] )ON [PRIMARY]'Exec (@SQL)SELECT @SQL_INS = 'INSERT INTO [Raw].dbo.[TEST1]('SELECT @SQL_INS = @SQL_INS + '[fID],[fName],[bid], [ask], [high] ,[low] , [bidTrend] , [askTrend] , [fTime]) SELECT [fID],[fName],[bid], [ask], [high] ,[low] , [bidTrend] , [askTrend] , [fTime] FROM [Raw].dbo.[AUD/CAD]'Exec (@SQL_INS) |
|
|
Q
Yak Posting Veteran
76 Posts |
Posted - 2006-06-30 : 10:27:30
|
| It seems you can define how much the log file is allowed to grow by percent. Another possiblity is that the maximum logfile sizze is defined... Can't do much more for you, but maybe it helps you out... |
 |
|
|
|
|
|
|
|
Primary filegroup is full