I'm hoping one of you SQL Server gurus can help me out here....
I came across a stored procedure that is supposedly designed to kill processes that have been lingering for too long. The part that finds who is hanging around looks like this (the "WSD401" part is my workstation ID on the network): SELECT SPID, last_batch, program_name, loginame, hostname, * FROM master..sysprocesses (NOLOCK) WHERE (spid>50 AND status='sleeping' AND DATEDIFF(mi,last_batch,GETDATE())>=120 AND spid<>@@spid) or hostname = 'WSD401' order by last_batch ; In the output I see several rows with a 'hostname' field of WSD401 but they are associated with users that have nothing to do with me or my workstation.... Or do they??? I would expect hostname to be unique for each machine - is that not the case? Maybe this column doesn't mean what I think it does? TIA, Matt Jarvis Programmer/DBA King | Retail Solutions 541-349-8512 Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
