Re: How to keep record of who logged on and who did what on the database

On 14 Mar 1997 17:25:51 GMT, sccstech_at_superlink.net (sccstech) wrote:

>
>I have encountered a situation, where the database server crashed on
>Windows NT Server because of virtual memory being run out. Somebody
>executed a query which returned 50000 rows.
>
>The server did not write any log like who waa trying to do what.
>
>Now, what can be the various ways to hadle a problem like this.
>
>Can we program the server soemhow to return an error that describes the
>quota being exceeded. This way, the server would not crash.
>
>What are other elegant solutions to avoid this kind of unexpected CRASH of
>the database server.
>
>
>
>Looking forward to the solution.
>
>Thanks
>
Maybe you can do something with auditing. You can audit several options. E.G. DML activities but also user activities.

I'm not sure, but can you give users limited quota for using memory ??

success. Received on Fri Mar 14 1997 - 00:00:00 CET