Professional Web Applications Themes

Any of way Capturing/Listing CurrentActivity.Process Information ??? - Microsoft SQL / MS SQL Server

In EnterpriseManager, Management Folder under CurrentActivities there is an option Process Info ... is there anyway of capturing that data (e.g in vb code) .Does SQL store it in a systemtable somewhere...

  1. #1

    Default Any of way Capturing/Listing CurrentActivity.Process Information ???

    In EnterpriseManager, Management Folder under CurrentActivities there is an
    option Process Info ...
    is there anyway of capturing that data (e.g in vb code) .Does SQL store it
    in a systemtable somewhere


    RKD Guest

  2. #2

    Default Re: Any of way Capturing/Listing CurrentActivity.Process Information ???

    You can quickly find what Enterprise Manager is doing by running the
    "Profiler" application and then clicking on the "Process Info" node. All the
    statements that Enterprise Manager sends to the SQL Server can then be
    captured.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    [url]http://www32.brinkster.com/srisamp[/url]

    "RKD" <ragubir_28hotmail.com> wrote in message
    news:8vcPa.17045$0e7.3115news-binary.blueyonder.co.uk...
    > In EnterpriseManager, Management Folder under CurrentActivities there is
    an
    > option Process Info ...
    > is there anyway of capturing that data (e.g in vb code) .Does SQL store it
    > in a systemtable somewhere
    >
    >

    SriSamp Guest

  3. #3

    Default Re: Any of way Capturing/Listing CurrentActivity.Process Information ???

    Excellent!
    Exactly what i needed.

    Thankyou

    "SriSamp" <ssampathsct.co.in> wrote in message
    news:#lC6GytRDHA.1720TK2MSFTNGP12.phx.gbl...
    > You can quickly find what Enterprise Manager is doing by running the
    > "Profiler" application and then clicking on the "Process Info" node. All
    the
    > statements that Enterprise Manager sends to the SQL Server can then be
    > captured.
    > --
    > HTH,
    > SriSamp
    > Please reply to the whole group only!
    > [url]http://www32.brinkster.com/srisamp[/url]
    >
    > "RKD" <ragubir_28hotmail.com> wrote in message
    > news:8vcPa.17045$0e7.3115news-binary.blueyonder.co.uk...
    > > In EnterpriseManager, Management Folder under CurrentActivities there is
    > an
    > > option Process Info ...
    > > is there anyway of capturing that data (e.g in vb code) .Does SQL store
    it
    > > in a systemtable somewhere
    > >
    > >
    >
    >

    RKD Guest

Similar Threads

  1. Replies: 9
    Last Post: March 8th, 11:36 PM
  2. Replies: 0
    Last Post: October 18th, 09:18 PM
  3. Replies: 6
    Last Post: May 17th, 07:08 PM
  4. Win32::Process Kill Process in Windows ME
    By Stefan Mueller in forum PERL Modules
    Replies: 3
    Last Post: April 15th, 07:35 PM
  5. Replies: 1
    Last Post: February 3rd, 09:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139