|
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?
(comments are locked)
|
|
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? The Primary file group was set to a autogrow, and set to a maxsize and it had hit that ceiling. My DBA kindly gave me 10GB and I was off to the races.
Nov 03 '09 at 05:28 PM
Raj More
It is a warehouse db, not TempDB. I just posted my SQL Statement in the question.
Nov 03 '09 at 05:31 PM
Raj More
(comments are locked)
|


question is not understandable to give solution . please explain more :)
Please mark Kevs answer as accepted, to give him the reputation points and to make it clear to other viewers that your question have a solution. :)