Plz try this

delete packaage packagename

I am not sure , if any command for dropping packages except below steps

In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to...

PLease use below

dbcc inputbuffer(spid)

plz use the below

select * from master..sysprocesses where blocked > 0

or

select spid,blocked from master..sysprocesses where blocked > 0

go

sp_who2 (SPID)

This is error i found fron SQL log

Database backed up. Database: OperationsManager, creation date(time): 2008/12/17(13:46:51), pages dumped: 637164, first LSN: 476:1227796:1, last LSN: 477:10953:1, number of dump devices: 1, device...

Please try the below

1. Put db to Simple recovery

2. increase the max size

3. run maint commands

4. change to FULL recovery

5. take a log dump

6. it its not ok, do shrink...

Please check any blockings,CPU and memeory usage in SQL server and find which process is taking high CPU utilization in SQL server

I ran the below statment on master DB

what can i do now. becuase i got the same alert again.

use master

go

DBCC USEROPTIONS

Results :

textsize 2147483647

language us_english

dateformatmdy

datefirst7

lock_timeout-1

quoted_identifierSET

arithabortSET

ansi_null_dflt_onSET

ansi_warningsSET

ansi_paddingSET

ansi_nullsSET

concat_null_yields_nullSET

isolation levelread committed

I am not sure. Pleaselet us know what is Read committed isolation level