I am trying to create a primary key (clustered across 6 columns on a 5 million row table)
When I execute my
I get the following error
How do I correct this?
Well I think you understand the error - there isn't any room left in the filegroup to create the index. Can you confirm that either the database isn't set to autogrow, or the disk that the filegroup is on is full?
Is the database name you have XXXd out tempDB or a user db?
Are you specifying the SORT_IN_TEMPDB option on the CREATE INDEX?
answered Nov 03, 2009 at 04:18 PM
Kev Riley ♦♦