Solved

one DB affecting processes

Posted on 2010-08-19
4
1,060 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

831 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