error in installing hot fix

i installed an service pack 2

Quick Details

Version:

9.00.3042

Knowledge Base (KB) Articles:

KB921896

Date Published:

3/6/2007

Language:

English

Download Size:

282.4 MB - 392.4 MB*

*Download size depends on selected download components.

the above installation , i was success. but the version is 9.00.3042. so what i did was i stalled the hot fix , http://support.microsoft.com/kb/933097

but this hox fis installation is success for all, but it failed for database services with below error message :

product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3152
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

now i don't know what to do...

i don't want to uninstall sqlserver 2005 and redo the whole thing...

because thisd is my first assinment in the new job and if i redo the whole thing then it won't be good since it'll take 1 week..

is there any way i can solve this issue?

A Knowledge Based article has been published explaining the problem and workaround:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695

Please let us know if this article does not address your problem.

Thanks,
Sam Lester (MSFT)

|||but i installed sp2.
the above kb is the issue with sp1