Unable to create index

[fogal]

I get the following error message when trying to create a new unique primary that increments. Total records = 5492520

What does the erroe message Primary filegroup full mean???
What should I do??

'xyz' table
- Unable to create index 'PK_xyz'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object '(SYSTEM table id: -5492520)' in database 'a123' because the 'PRIMARY' filegroup is full.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

 

[nigelrivett]

It means that the file that contains the database is full.
If you have a single mdf file and it is set to grow unconditionally it means that you disk is full.

Try
sp_helpdb 'mydbname'

It will tell you the filename.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.