Hi all

Yep, had this problem too, it was a fresh install of sqkserver 2k ee then sp3, i didnt check if it was sp3 though (unfortunatly) and I didnt have the time to go back.

Anyhow, the unload and lodctr.exe OP worked fine, BUT, I did have to reboot the server, a simple instance restart didnt work. Also note that I had to do it twice! (very strange indeed). Subsequent reboots and instance restarts are not a problem.

Also be aware of a SP3 bug. If you have a perf mon trace running, stop then restart the instance with the perfmon trace going, you will get a shared memory counter error in your sql server log. Not all the counters are affected but certainly the transaction/sec etc counters are. Search on support and you will see mention of it.

Cheers

Ck