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 |
|
kenchee
Starting Member
49 Posts |
 Posted - 2009-02-23 : 00:21:58
|
| Hi, I was wondering if anyone else with SQL2005 SP3 CU1 (9.0.4207) is experiencing this issue (ghost row cleanup thread not working)?I had a look into sys.dm_exec_requests and I could not find any ghost cleanup thread. Can someone help? ThanksRegardsKen |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 11:05:47
|
| http://support.microsoft.com/?kbid=932115 |
 |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2009-02-24 : 15:26:15
|
| Hi sodeep, Thanks. I've read through this. This is pre SP2. I've manage to get it fixed by installing SP3 CU2 (9.0.4211). Although, CU2 doesn't say anything about ghost row cleanup but it's working now after I've applied SP3 CU2.Ken |
|
|
|
|
|
|
ghost row cleanup thread not working after sp3 cu1