Printable View
Hi all:
I need some help with this. I have a development server and all the developers log in as sa. Lately test data has been mysteriously deleted from selected tables. I need to track the time that the activity is taking place so I can figure out who might be playing this little game. Can anyone suggest what I can do to find this out? Your quick response will be appreciated.
You`ll think this is a shameless plug, but it isn`t. Check out SQL Auditor from dbSecure. you`ll get a ton of informaion on logins and security levels and suggestions for managing, controlling and so forth against these resources.
If you`re interested, they (dbSecure) do have a discussion forum here on swynk that will let you ask questions, etc. and find out more about their software. I`ve used it and it`s really comprehensive. Just open the 3rd Pty Help menu to the left and go to SQL Auditor.
From there, you could set up triggers and dump the rows to a different table when deleted, track the user, etc.
HTH
SW
On 9/23/98 9:42:23 AM, wrote:
> Hi all:
I need some help with this. I have a development server and all
> the developers log in as sa. Lately test data has been mysteriously
> deleted from selected tables. I need to track the time that the activity
> is taking place so I can figure out who might be playing this little game.
> Can anyone suggest what I can do to find this out? Your quick response
> will be appreciated.
MSSQL Server has its own utility called - SQL Trace or use xp_sqltrace.
Both allow database administrators and application developers to monitor and record database activity. Multiple instances of xp_sqltrace can be run simultaneously.
VK.
Thanks. I requested an eval copy.
On 9/23/98 9:53:14 AM, Stephen Wynkoop wrote:
> You`ll think this is a shameless plug, but it isn`t. Check out SQL Auditor
> from dbSecure. you`ll get a ton of informaion on logins and security
> levels and suggestions for managing, controlling and so forth against these
> resources.
If you`re interested, they (dbSecure) do have a discussion
> forum here on swynk that will let you ask questions, etc. and find out more
> about their software. I`ve used it and it`s really comprehensive. Just
> open the 3rd Pty Help menu to the left and go to SQL Auditor.
From
> there, you could set up triggers and dump the rows to a different table
> when deleted, track the user, etc.
HTH
SW
On 9/23/98 9:42:23 AM,
> wrote:
> Hi all:
I need some help with this. I have a development
> server and all
> the developers log in as sa. Lately test data has been
> mysteriously
> deleted from selected tables. I need to track the time
> that the activity
> is taking place so I can figure out who might be
> playing this little game.
> Can anyone suggest what I can do to find
> this out? Your quick response
> will be appreciated.