SQL Server deletes user 15434 error

Source: Internet
Author: User

The sysprocesses table holds information about the processes running on Microsoft®sql Server™. These processes can be either client processes or system processes. sysprocesses are only stored in the master database.

Column name Data type description
SPID smallint SQL Server process ID.
Kpid smallint Microsoft Windows NT 4.0® thread ID.
Blocked smallint the process ID (spid) of the chunked process.
waittype binary (2) reserved.
waittime int The current wait time, in milliseconds. When the process is not waiting, it is 0.
Lastwaittype NCHAR (32) represents the string of the last or current wait type name.
Waitresource nchar (32) A textual representation of the lock resource.
dbid smallint The database ID currently being used by the process.
UID smallint the user ID of the execution command.
The cumulative CPU time of the CPU int process. This entry is updated for all processes, regardless of whether the SET STATISTICS time on option is on or OFF.
Physical_io the cumulative disk reads and writes of the int process.
Memusage int the number of pages in the process cache currently assigned to the process. A negative number that indicates that the process is releasing memory allocated by another process.
Login_time datetime When the client process logs on to the server. For system processes, the time at which SQL Server startup occurs is stored.
Last_batch the time that the datetime client process last executed a remote stored procedure call or EXECUTE statement. For system processes, the time at which SQL Server startup occurs is stored.
Ecid smallint is used to uniquely identify the execution context ID of a child thread acting on behalf of a single process.
Open_tran the number of open transactions for the smallint process.
Status nchar (30) Process ID state (such as run, hibernate, etc.).
Sid Binary (85) the user's globally unique identifier (GUID).
Hostname NCHAR (128) The name of the workstation.
Program_name NCHAR (128) The name of the application.
Hostprocess NCHAR (8) Workstation process ID number.
CMD nchar (16) The command that is currently executing.
Nt_domain NCHAR (128) a client's Windows NT 4.0 domain (if Windows authentication is used) or a trusted connection to a Windows NT 4.0 domain.
Nt_username NCHAR (128) The Windows NT 4.0 user name for the process (if Windows authentication is used) or the Windows NT 4.0 user name that is trusted for the connection.
Net_address NCHAR (12) assigns a unique identifier to the network interface card on each user workstation. When the user logs on, the identifier is inserted into the net_address column.
Net_Library NCHAR (12) is used to store the columns of the Client network library. Each client process is entered on a network connection. Network connections have a network library associated with these processes that enable these processes to establish connections. For more information, see Client and server Net-library.
Loginame NCHAR (128) login name.

SELECT Spid,net_library,hostname,program_name,nt_domain,nt_username,loginame from sys.sysprocesses

Suppose Spid=100,kill 100

SQL Server deletes user 15434 error

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.