Sysprocesses - Status EXECUTE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve Hennessey (steve_at_hennessey.net)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 01:48:32 -0700

HELP! I'm BOL'd out & I'm Googled out. I can find one similar question
being asked once, but absolutely no answer to the question.

... and here it is....

When I execute SP_WHO2 I often see .NET connections in an 'EXECUTE'
status.

What does status = 'EXECUTE' actually mean?

A million thanks in advance,
Steve.

Windows 2003 Server
SQL Server 2000 SP3a

Relevant Pages

  • Re: Permission for Importing data.
    ... database owner to execute xp_cmdshell. ... the SQL Server service is running. ... Microsoft® Windows NT® 4.0 and Windows 2000. ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)
  • Re: Calling External Progs
    ... When you grant execute permissions to users, ... account running Microsoft SQL ServerT has the needed privileges to execute. ... which the SQL Server service is running. ... Microsoft® Windows NT® 4.0 and Windows 2000. ...
    (microsoft.public.sqlserver.security)
  • Re: SSIS - OLE DB Command - how to retrieve query results ???
    ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
    (microsoft.public.sqlserver.dts)