Craig,

This is a very good solution on second read. I appreciate the comments. So if I set up the auto trace on the server itself and have it...

I suppose I could auto start a trace, but it's not worth the extra hit on the server for something that is of fairly minor importance.

Too much work and processing...

tracing doesn't do it because I need to constantly count # of queries of certain users, not for one day, but always.

It's used to report on trends of # of...

It seems I cannot use an event notification. There is no trace event I can use to create the event notification with.

I tried using some of the SQL trace...

Jeff,

Thanks.

It works well.

Steve

I made a workaround using another table.

persistently. We create reports for average query counts per hour for the current month and for previous months.

If I did the job, I doubt that statements would be swapped...

Gail,

First - thanks for taking time to looking at this.

What I mean is I need to find what the average count of rows is per day, grouped by hour.

The table...

create table sg

(EventTime datetime)

insert into sg values('02/01/10 07:17:00')

insert into sg values('02/01/10 07:33:00')

insert into sg values('02/01/10 07:46:00')

insert into sg values('02/01/10 08:10:00')

insert into sg values('02/01/10 08:37:00')

insert into sg values('02/02/10 07:57:00')

insert into sg...

I implemented the event notification as described in http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/

on a development database.

Referring to that link, suppose I want to limit the logins inserted into my table with a where clause...

I do not have the time to make the request to get admin rights to do this.

Thanks for the help anyway!

I tried the full UNC path. Still did not work.

I will try to get write privileges to that drive for the id that runs the sql server service and...

Yes, now I realize the MarkusB query is good.

Do we know if perfmon would give the same results if I looked for processor objects and counters?

I am not familiar...

we are auditing failed logins, which go to the sql server error log.

I need successful logins to go to a table, so I can generate a report from it.

I considered auditing successful logins, then reading the error log, but I prefer the other options which I think are easier in accomplishing what I want.

Only failed logins are being...