Re: aduit connections to SQL Server

Andrew
In addition on Sue's reply
Not to long ago we had some records deleted out of the sql database
mysteriously. I am trying to find out how that happened and to keep it
from
happening again.


You can use
1) DDL Triggers
2) Event notifications





"Andrew" <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B1D1BB3-9EC2-4C31-87FA-064A1FB5C2E0@xxxxxxxxxxxxxxxx
On sql 2005 is there any audit logs on by default that log connections to
sql
server and what database the connection was to.

If not on, is there one that you can turn on.

Not to long ago we had some records deleted out of the sql database
mysteriously. I am trying to find out how that happened and to keep it
from
happening again.



.

Relevant Pages

  • Re: Help me with VPN
    ... You would need the NT server to be able to receive VPN calls. ... > office MS SQL database using the system we've created. ... > branch with both aDSL connection of 384Kbps. ...
    (microsoft.public.backoffice.smallbiz)
  • Our server just went down...what might be causing this?
    ... Our site is built on .net and connects to a MS SQL database on another ... Our DB connection is down. ... Microsoft OLE DB Provider for SQL Server ... some ASPX pages can no longer be 'found' by ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL .NET STRING PROBLEM
    ... establish a connection with my sql database, that is in a MS 2003 server. ... message SQL SERVER DOES NOT EXISTS, but If I dont' do it I am getting the ...
    (microsoft.public.dotnet.framework)
  • ADO.NET via Javascript
    ... Is there any code out there that explains how to perform a connection to a SQL Database and returning a Dataset using Javascript. ... I'd like to perform certain functions on the client without having to send the entire page to the server... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL connections
    ... I would suggest to close connection as soon as possible. ... require additional resources from the server. ... > connections to AS/400 database and my SQL Database, ...
    (microsoft.public.dotnet.framework.adonet)