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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Testing reindexing

Author  Topic 

fcoreyesv
Starting Member

18 Posts

Posted - 2006-06-09 : 09:38:54
I found a script to reindex all the user tables in a database. For testing purposes I would like to know how to make a reindexing process to fail.

If someone knows, will be greatly appreciated.

Thanks

Francois

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 02:04:17
Disk full? as Reindex will extend the database quite a bit (you may need to shrink it first so there isn't enough free space for the reindex)

Kristen
Go to Top of Page
   

- Advertisement -