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!

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

MMC "Command" status ?

Status
Not open for further replies.
JamesJKusch

JamesJKusch

MIS
Mar 27, 2001
29
0
0
US
Having an issue. There is a spid in the "Process Info" folder under "Management" in Enterprise Manager, MMC, that is hanging. What i have a question on is under the "Command" header of the "Process Info folder, between "Open Transactions" and "Application", that states "Conditional". I have seen most of course saying "Awaiting Command", "Select Into", "Log Writer" and a host of others i am framiliar with, but not "Conditional". Is this state telling me it is processing a conditional statement and that i may be seeing an iteration of some sort in the procedure or is it relevent to some other issue at hand. Thanks for all your help!!!


J. Kusch Thanks for all the help ... As Usual

J. Kusch
Chameleon Solutions, Inc.
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
736
gmmastros
gmmastros
grnzbra
  • Locked
  • Question
Why the "WITH" Format 1
Replies
12
Views
109
TamarGranor
TamarGranor
Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
55
ggriffit
ggriffit
Auguy
  • Locked
  • Question
SQL 2104 "Check For Updates" Not Listed Under Tools
Replies
0
Views
36
Auguy
Auguy
BigDave619
  • Locked
  • Question
NZ(DLookup) changed from "Number" field to "Text" field 1
Replies
4
Views
57
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top