Hi,
I need to tune up an application and I'd like to enable sql tracing to see
how query are made.
I've search around to see how I can do but I've find nothing.
I'm using adodb object with a connection string to connect to my sqlserver.
HEGMS wrote:
> Hi,
> I need to tune up an application and I'd like to enable sql tracing
> to see how query are made.
> I've search around to see how I can do but I've find nothing.
> I'm using adodb object with a connection string to connect to my
> sqlserver.
Use SQL Profiler, which is one of the client tools that comes with sql
server.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Thx, I've found this tools but I was just looking at a method that should be
call from the asp code because (except in my case) devlopper do not have
access to sql server !
"Bob Barrows [MVP]" wrote:
> HEGMS wrote:
> > Hi,
> > I need to tune up an application and I'd like to enable sql tracing
> > to see how query are made.
> > I've search around to see how I can do but I've find nothing.
> > I'm using adodb object with a connection string to connect to my
> > sqlserver.
>
> Use SQL Profiler, which is one of the client tools that comes with sql
> server.
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>
I believe you can use SQL DMO (or SMO depending on the version of SQL
you are using) for this. However, this will require installing it on the
web server, something which your host provider may frown on.
If you wish to pursue that option, you will need to post to a sqlserver
programming group.
HEGMS wrote:
> Thx, I've found this tools but I was just looking at a method that
> should be call from the asp code because (except in my case)
> devlopper do not have access to sql server !
>
> "Bob Barrows [MVP]" wrote:
>
>> HEGMS wrote:
>>> Hi,
>>> I need to tune up an application and I'd like to enable sql tracing
>>> to see how query are made.
>>> I've search around to see how I can do but I've find nothing.
>>> I'm using adodb object with a connection string to connect to my
>>> sqlserver.
>>
>> Use SQL Profiler, which is one of the client tools that comes with
>> sql server.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.