On Tue, Sep 9, 2008 at 3:28 PM, Matt Jarvis <[EMAIL PROTECTED]> wrote: > 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): ----------------------------------------
why not use sp_who or sp_who2 ? On top of that you can go into Management | Activity Monitor to give you a great deal of data about WHAT and WHOM is on your server from SM. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ 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.
