tracking users

[Jenise]

Hi,

What's the best way to track what stored procedures are
being used along with the variables that are being passed
to them? I'm thinking that is the best and/or easiest way
to track which users are accessing my website.

ASP is my front-end app to SQL 2K. I'm using a cgi
variable to capture the users NT username and then passing
that to a stored procedure in sql server to verify that
they have access to the site. I'm using a generic user
group role that I created in SQL 2K for all the users in
the site.

I originally began using sql profiler, but I would have to
constantly keep that running. Is there stored procedure
that I can periodically run to view all the variables that
have been passed back to my stored procedures during a
specified time period?

Any suggestions are greatly appreciated.
Thank You,
Jenise

[Cowboy \(Gregory A. Beamer\)]

You can slap the variables on the querystring and run it that way. Many web
log packages will do that.

Another method is to alter your stored procedure to set up a basic logging
mechanism. You can log user's sessions fairly easily. If you set up your own
database with the IP address, you can compare this to the web logs for a
more full picture.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Jenise" <anonymous@discussions.microsoft.com> wrote in message
news:0b9501c397ea$fb8c1930$a601280a@phx.gbl...

> Hi,
>
> What's the best way to track what stored procedures are
> being used along with the variables that are being passed
> to them? I'm thinking that is the best and/or easiest way
> to track which users are accessing my website.
>
> ASP is my front-end app to SQL 2K. I'm using a cgi
> variable to capture the users NT username and then passing
> that to a stored procedure in sql server to verify that
> they have access to the site. I'm using a generic user
> group role that I created in SQL 2K for all the users in
> the site.
>
> I originally began using sql profiler, but I would have to
> constantly keep that running. Is there stored procedure
> that I can periodically run to view all the variables that
> have been passed back to my stored procedures during a
> specified time period?
>
> Any suggestions are greatly appreciated.
> Thank You,
> Jenise
>

[Jenise]

Thanks for the idea, I'll try that.

Jenise :)

>-----Original Message-----
>You can slap the variables on the querystring and run it

that way. Many web

>log packages will do that.
>
>Another method is to alter your stored procedure to set

up a basic logging

>mechanism. You can log user's sessions fairly easily. If

you set up your own

>database with the IP address, you can compare this to the

web logs for a

>more full picture.
>
>--
>Gregory A. Beamer
>MVP; MCP: +I, SE, SD, DBA
>
>************************************************* *********

************

>Think Outside the Box!
>************************************************* *********

************

>"Jenise" <anonymous@discussions.microsoft.com> wrote in

message

>news:0b9501c397ea$fb8c1930$a601280a@phx.gbl...

>> Hi,
>>
>> What's the best way to track what stored procedures are
>> being used along with the variables that are being

passed

>> to them? I'm thinking that is the best and/or easiest

way

>> to track which users are accessing my website.
>>
>> ASP is my front-end app to SQL 2K. I'm using a cgi
>> variable to capture the users NT username and then

passing

>> that to a stored procedure in sql server to verify that
>> they have access to the site. I'm using a generic user
>> group role that I created in SQL 2K for all the users in
>> the site.
>>
>> I originally began using sql profiler, but I would have

to

>> constantly keep that running. Is there stored procedure
>> that I can periodically run to view all the variables

that

>> have been passed back to my stored procedures during a
>> specified time period?
>>
>> Any suggestions are greatly appreciated.
>> Thank You,
>> Jenise
>>

>
>
>.
>