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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-26 : 21:18:47
|
| Reorganize Index job is failing for user databasesLog Report says:Failed (-1073548784) Executing the query 'ALTER INDEX [ams_1v11_alerts_groupcount] ON [dbo].[ams_1v11_alerts] REORGANIZE WITH (LOB_COMPACTION=ON)"failed with the following error:"The index"ams_1v11_alerts_groupcount" (partition 1) on table "ams_1v11_alerts" cannot be reorganized because page level locking is disabled.".possible failure reasons:Problems with the query ,"ResultSet" property not set correctly, parameters not set correctly, or connection not estabilished correctly.I have already running REBUILD INDEX job every suday 1 AM.Please advice is it necessary to run both REORGANIZE INDEX and REBUILD INDEX ??? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-26 : 22:02:31
|
| Try run above statement in ssms query window to see what happens. By the way, don't need to run both REORGANIZE INDEX and REBUILD INDEX at same day. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-26 : 22:22:30
|
| What is the deference between Reorganize Index and RebuildIndex??Is it okay to run only REBUILD INDEX on this server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-26 : 22:56:24
|
| Check books online for the difference. >> Is it okay to run only REBUILD INDEX on this server?Depends on table size, degree of fragmentation and query performance. |
|
|
|
|
|
|
sql 2005-ReorganizeIndex job is failing