Solved

one DB affecting processes

Posted on 2010-08-19
4
1,057 Views
Last Modified: 2012-08-13
When I run sys.sysprocesses or sp_who2, i get
Msg 952, Level 16, State 1, Procedure sp_who2, Line 89
Database 'TRACKER' is in transition. Try the statement later.

why would one DB put a hold on all?

thanks
0
Comment
Question by:anushahanna
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 500 total points
ID: 33480024
Management Studio probably has a lock on some system table. Try stopping all running instances of management studio and try the query again.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33484592
>>instances of management studio

do you mean multiple instances of sqlwb.exe?
0
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 500 total points
ID: 33486833
yes, if you are using sql server 2005 its sqlwb.exe. SQL server 2008 uses ssms.exe
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33487377
It seemed to help. thanks mcv22.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now