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 |
|
marat
Yak Posting Veteran
85 Posts |
 Posted - 2005-05-22 : 19:45:35
|
| I am receiving the following message:if exists (select 1 from sysobjects where name = 'T_myTable' and type = 'U') DBCC DBREINDEX ('[dbo].[T_myTable]') WITH NO_INFOMSGS 2005-05-22 00:22:37.207 [SQLSTATE 01000]Msg 1105, Sev 17: Could not allocate space for object '(SYSTEM table id: -15008193)' in database 'myDatabase' because the 'RD_DATA' filegroup is full. [SQLSTATE 42000]Msg 3621, Sev 17: The statement has been terminated. [SQLSTATE 01000]My question would be: How much space required to rebuild index? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-22 : 22:54:44
|
| It rebuilds with the original fillfactor unless you specify one - that could be causing your problem.How much free space do you have?==========================================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. |
 |
|
|
marat
Yak Posting Veteran
85 Posts |
Posted - 2005-05-22 : 23:13:36
|
| There is 15G free space available.The largest index on table holds 18G, actually this is a table I am talking about. My guess would be: at least have max(index size) in DB available plus some(???) additional space.Fill factor is set to default. |
|
|
|
|
|
|
DBCC DBREINDEX