Awaiting Command

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Lontae Jones (LontaeJones_at_discussions.microsoft.com)
Date: 07/23/04


Date: Fri, 23 Jul 2004 11:14:02 -0700

I have 10 severs that login to my database and after an sp_who2 I noticed all of them have Awaiting Command. Is this normal or reason why our front end app is not functioning?



Relevant Pages

  • Restrict use of Multiple Users for the Same Login
    ... Use cookies to uniquely identify the client's web browser and thus the login to the database. ... Using the SET CONTEXT_INFO store the login of the user and compare it to the list of users each time logged into the database. ... Reason: Still falls prey to the same problem of connections constantly being opened and closed by the web pages. ...
    (microsoft.public.sqlserver.programming)
  • Users in database have no associated login
    ... some reason, the users in our database don't have associated logins (as seen ... databases the users of our database have the sa login associated with them. ... name is blank for the dbo user... ...
    (microsoft.public.sqlserver.security)
  • Users in database have no associated login
    ... some reason, the users in our database don't have associated logins (as seen ... databases the users of our database have the sa login associated with them. ... name is blank for the dbo user... ...
    (microsoft.public.sqlserver.server)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)