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

dateformat mdy

datefirst 7

lock_timeout -1

quoted_identifier SET

arithabort SET

ansi_null_dflt_on SET

ansi_warnings SET

ansi_padding SET

ansi_nulls SET

concat_null_yields_null SET

isolation level read committed

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