Re: How to view process information from Query Manager
From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 10/04/02
- Next message: Rob: "Re: SSL Encryption"
- Previous message: Mark Allison: "Re: Event ID: 17055; 18456 : Login failed for user 'sa'."
- In reply to: david: "Re: How to view process information from Query Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Andrew J. Kelly" <akelly@targitinteractive.com> Date: Fri, 4 Oct 2002 08:09:27 -0400
DBCC INPUTBUFFER will give the same as dblclking in EM.
-- Andrew J. Kelly SQL MVP Targitinteractive, Inc. Check out the PASS Community Summit - Seattle, the largest and only user event entirely dedicated to SQL Server, November 19-22. http://www.sqlpass.org/events/seattle/index.cfm "david" <dly19@hotmail.com> wrote in message news:Oxb1gc5aCHA.952@tkmsftngp12... > thanks for replying, sp_who only give me a list of processes. I am after the > process information of each spid, showing the actual command (SQL) the > process is running. > > "Jobi" <johan.bijnens_n_o_s_p_a_m@alz.be> wrote in message > news:anjf9f$g8r$1@reader13.wxs.nl... > > sp_who or sp_who2 could be what you're looking for > > > > jobi > > "david" <nospam-noreply@nospam.com> wrote in message > > news:OAd6AJ2aCHA.1556@tkmsftngp08... > > > I would like to allow the programmer to view the process information > > > (similar to double clicking on the process on 'Process Info' in > Enterprise > > > manger), using query manager. > > > > > > Anyone can show me to the right direction ? > > > > > > Thanks > > > David > > > > > > > > > > > >
- Next message: Rob: "Re: SSL Encryption"
- Previous message: Mark Allison: "Re: Event ID: 17055; 18456 : Login failed for user 'sa'."
- In reply to: david: "Re: How to view process information from Query Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
