by hipp » Wed, 19 Dec 2001 07:18:35
We are finding multiple login and logoff events being recorded in the NT
event log when using an access database front-end. Why would this be the
case? The events happen multiple times during a single second.
Does it have to login and logout for every row of data returned or every
query run?
Thanks for any insight!
hip
by Dinesh T » Wed, 19 Dec 2001 07:31:53
Right click on the sqlserver | properties and in the security tab check for
the audit level option selected.
Dinesh.
Quote:> Hi,
> We are finding multiple login and logoff events being recorded in the NT
> event log when using an access database front-end. Why would this be the
> case? The events happen multiple times during a single second.
> Does it have to login and logout for every row of data returned or every
> query run?
> Thanks for any insight!
> hip
by hipp » Wed, 19 Dec 2001 07:38:21
> Right click on the sqlserver | properties and in the security tab check
for
> the audit level option selected.
> Dinesh.
> > Hi,
> > We are finding multiple login and logoff events being recorded in the NT
> > event log when using an access database front-end. Why would this be the
> > case? The events happen multiple times during a single second.
> > Does it have to login and logout for every row of data returned or every
> > query run?
> > Thanks for any insight!
> > hip
1. Three event logged in the event view About SQLAgent whenever clear the event logs or failover
Whenever I failover over a second node or clear the event log in the event
view I ended up three logs about SQLAgent; error, warning and good. One of
the event log had event ID: 318.
I had been searching on the Technet and I was not able to find out how I
would clear those errors out. As far the Virtual SQL and SQLAgent service
they worked fine.
Anyone experienced the same thing and had resolved please email the
resolution.
Thanks,
Steve
2. A97 FE, SQL7 BE, #deleted problem
3. unable to read login packet(s) event in event viewer
4. Enterprise Manager Question...
5. Need List of ALL Events written to Event Logs
6. LOGTO LAG
7. Event Log overflow with 18453 & 18454 events
8. Help !!!
9. Event Application log event id 106
10. xp_cmdshell event logging event 17055
11. Stop Transaction Logs backups writing to NT Event Logs
12. Logging of SQL messages on the NT event log