Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

process id deadlock causing error in shrinking db

Status
Not open for further replies.

Paulvtis

MIS
Aug 1, 2002
36
PH
Am trying to shrink a database but error comes out always about deadlock with a process ID. when i killed the process, another deadlock occurs with another process.

does this mean when am shrinking a db users cannot query reports from the said db? can't it be simultaneous since it is just report query from a visual basic program?

moreover, there is one process in runnable status that i can't kill. it is always there in the process id listing.

tnx
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top