capturing SQL from .NET app.

Discussion in 'ASP .Net Web Services' started by Stephen, Jan 10, 2008.

  1. Stephen

    Stephen Guest

    Hi Folks,

    Not sure if I'm in the right place, but I'm looking for information on how I
    can capture a SQL query tht is generated from a .net / .aspx file.

    I have a web based application that allows me to run reports and specify my
    criteria. I want to be able to capture the query that is run against the
    database. I'm thinking along the lines of SQL Profiler but my DB is Pervasive.

    Any help or directions to better places to post this question are greatly
    appreciated.

    TIA!

    Steve
    Stephen, Jan 10, 2008
    #1
    1. Advertising

  2. Stephen

    JIGNESH Guest

    To know which SQL commend is execting on DB. there are two ways that i know
    SQLProfiler and Stored Procedure SP_WHO or SP_Who2 which you can run in
    QueryAnalyzer.

    Regards
    JIGNESH

    "Stephen" wrote:

    > Hi Folks,
    >
    > Not sure if I'm in the right place, but I'm looking for information on how I
    > can capture a SQL query tht is generated from a .net / .aspx file.
    >
    > I have a web based application that allows me to run reports and specify my
    > criteria. I want to be able to capture the query that is run against the
    > database. I'm thinking along the lines of SQL Profiler but my DB is Pervasive.
    >
    > Any help or directions to better places to post this question are greatly
    > appreciated.
    >
    > TIA!
    >
    > Steve
    JIGNESH, Jan 11, 2008
    #2
    1. Advertising

  3. Stephen

    Stephen Guest

    I would do just that but the problem is my DB is Pervasive SQL

    "JIGNESH" wrote:

    > To know which SQL commend is execting on DB. there are two ways that i know
    > SQLProfiler and Stored Procedure SP_WHO or SP_Who2 which you can run in
    > QueryAnalyzer.
    >
    > Regards
    > JIGNESH
    >
    > "Stephen" wrote:
    >
    > > Hi Folks,
    > >
    > > Not sure if I'm in the right place, but I'm looking for information on how I
    > > can capture a SQL query tht is generated from a .net / .aspx file.
    > >
    > > I have a web based application that allows me to run reports and specify my
    > > criteria. I want to be able to capture the query that is run against the
    > > database. I'm thinking along the lines of SQL Profiler but my DB is Pervasive.
    > >
    > > Any help or directions to better places to post this question are greatly
    > > appreciated.
    > >
    > > TIA!
    > >
    > > Steve
    Stephen, Jan 11, 2008
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?QnJldA==?=

    Capturing SQL Recordset to Control

    =?Utf-8?B?QnJldA==?=, Mar 1, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    392
    =?Utf-8?B?QnJldA==?=
    Mar 1, 2007
  2. Kat
    Replies:
    0
    Views:
    309
  3. ecoolone
    Replies:
    0
    Views:
    753
    ecoolone
    Jan 3, 2008
  4. Headless Rider

    Control asp.net app from other asp.net app

    Headless Rider, Aug 18, 2003, in forum: ASP .Net Security
    Replies:
    0
    Views:
    98
    Headless Rider
    Aug 18, 2003
  5. JeffQ888
    Replies:
    0
    Views:
    181
    JeffQ888
    May 23, 2006
Loading...

Share This Page