Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

one DB affecting processes

Posted on 2010-08-19
4
Medium Priority
?
1,068 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 2000 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 2000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Viewers will learn how the fundamental information of how to create a table.

730 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