MSDN LINK<\/a><\/p>\n<\/p>\n
sp_who (T-SQL)<\/h2>\n
Provides information about current Microsoft\u00c2\u00ae SQL Server\u00e2\u201e\u00a2 users and processes. The information returned can be filtered to return only those processes that are not idle.<\/p>\n
Syntax<\/h5>\n
sp_who<\/strong> [[@login_name =<\/strong>] ‘<\/strong>login<\/em>‘<\/strong>]<\/p>\nArguments<\/h5>\n\n- [@login_name =<\/strong>] ‘<\/strong>login<\/em>‘<\/strong><\/dt>\n
- Is a user login name on SQL Server. login<\/em> is sysname<\/strong>, with a default of NULL. If no name is specified, the procedure reports all active users of SQL Server. login<\/em> can also be a specific process identification number (SPID). To return information on active processes, specify ACTIVE<\/strong>. ACTIVE<\/strong> excludes from the report processes that are waiting for the next command from the user.<\/dd>\n<\/dl>\n
Return Code Values<\/h5>\n
0 (success) or 1 (failure)<\/p>\n
Result Sets<\/h5>\n
\n\n| Column<\/th>\n | Data type<\/th>\n | Description<\/th>\n<\/tr>\n<\/table>\nRemarks<\/h5>\nA blocking process (which may have an exclusive lock) is one that is holding resources that another process needs.<\/p>\n Permissions<\/h5>\nExecute permissions default to the public<\/strong> role.<\/p>\nExamples<\/h5>\nA. List all current processes<\/h5>\nThis example uses sp_who<\/strong> without parameters to report all current users. In this example, process ID 11 (a SELECT on a table) is blocked by process ID 10 (an uncommitted transaction).<\/p>\nUSE master<\/code><\/p>\nEXEC sp_who<\/code><\/p>\n\u00c2 \u00c2 <\/code><\/em><\/strong><\/p>\nHere is the result set:<\/p>\n spid\u00c2 \u00c2 status\u00c2 \u00c2 \u00c2 loginame hostname\u00c2 blk\u00c2 \u00c2 dbname\u00c2 \u00c2 \u00c2 \u00c2 cmd
\n----- ---------\u00c2 -------- --------- ----- ---------- ----------------
\n1\u00c2 \u00c2 \u00c2 \u00c2 sleeping\u00c2 \u00c2 sa\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 0\u00c2 \u00c2 \u00c2 \u00c2 master\u00c2 \u00c2 \u00c2 \u00c2 MIRROR HANDLER
\n2\u00c2 \u00c2 \u00c2 \u00c2 sleeping\u00c2 \u00c2 sa\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 0\u00c2 \u00c2 \u00c2 \u00c2 master\u00c2 \u00c2 \u00c2 \u00c2 LAZY WRITER
\n3\u00c2 \u00c2 \u00c2 \u00c2 sleeping\u00c2 \u00c2 sa\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 0\u00c2 \u00c2 \u00c2 \u00c2 master\u00c2 \u00c2 \u00c2 \u00c2 CHECKPOINT SLEEP
\n4\u00c2 \u00c2 \u00c2 \u00c2 sleeping\u00c2 \u00c2 sa\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 0\u00c2 \u00c2 \u00c2 \u00c2 master\u00c2 \u00c2 \u00c2 \u00c2 RA MANAGER
\n10\u00c2 \u00c2 \u00c2 sleeping\u00c2 \u00c2 janetl\u00c2 \u00c2 SEATTLE1\u00c2 0\u00c2 \u00c2 \u00c2 \u00c2 pubs\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 AWAITING COMMAND
\n11\u00c2 \u00c2 \u00c2 runnable\u00c2 \u00c2 stevenb\u00c2 LONDON2\u00c2 \u00c2 10\u00c2 \u00c2 \u00c2 pubs\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 SELECT\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 \u00c2 <\/code><\/p>\n\u00c2 \u00c2 <\/code><\/em><\/strong><\/p>\nB. List a specific user\u00e2\u20ac\u2122s process<\/h5>\nThis example shows how to view information about a single current user by login name.<\/p>\n USE master<\/code><\/p>\nEXEC sp_who 'janetl'<\/code><\/p>\n\u00c2 \u00c2 <\/code><\/em><\/strong><\/p>\nC. Display all active processes<\/h5>\nUSE master<\/code><\/p>\nEXEC sp_who 'active'<\/code><\/p>\n\u00c2 \u00c2 <\/code><\/em><\/strong><\/p>\nD. Display a specific process with process ID<\/h5>\nUSE master<\/code><\/p>\nEXEC sp_who '10' --specifies the process_id<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"Provides information about current Microsoft\u00c2\u00ae SQL Server\u00e2\u201e\u00a2 users and processes. The information returned can be filtered to return only those processes that are not idle. Syntax sp_who [[@login_name =] ‘login‘] Arguments [@login_name =] ‘login‘ Is a user login name on SQL Server. login is sysname, with a default of NULL. If no name is specified, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,9],"tags":[],"class_list":["post-252","post","type-post","status-publish","format-standard","hentry","category-sql","category-sql-server","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":0,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
|