Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    40

    Unhappy Unanswered: get script of process

    Hi,
    Is there any sp to find script of a running process.
    R how can get the script of the running process..

    Kindly help

  2. #2
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    David Maxwell
    Data Integrity? Yeah, I've heard of that...

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    I recently found a nice little proc thru GOOGLE named dba_whatsqlisexecuting for MSSQL 2005. It shows both executing query and parent query for active processes. It errors out when reindexing statements are running, but all in all it's a pretty nice piece of work.

    I tried to include it in this post with the CODE tags, but got an error message that it was too long. you can go search for it.

    kudos to the author ... Ian_Stirk@yahoo.com

    -- This is all just a Figment of my Imagination --

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Ola Hallengren also did a lot of good stuff too, she has some pretty nifty maintenance routines for DBAs.

Posting Permissions

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