Date parsed: 19/10/2007 06:20:07
Date: Fri, 19 Oct 2007 10:20:07 -0400
Thanks for the advice.
On 10/19/07 9:49 AM, in article #$hWWblEIHA.6120@TK2MSFTNGP05.phx.gbl,
"Russell Fields" <russellfields@nomail.com> wrote:
> Noah,
>
> There is nothing after the fact to tell you who made changes to certain rows
> of data. You can set up some methods that would catch future changes, such
> as:
>
> 1. Use stored procedures for updates to data and have the stored procedure
> records the user who made the change.
> 2. Use triggers on your tables to insert data into a audit table that
> records changes,
> 3. Use SQL Trace and SQL Profiler to track all commands against the
> database.
>
> And so on. All of these have some overhead involved and have different
> rights issues and limitations. I have listed them in what I believe to be
> the lowest to highest server impact.
>
> In SQL Server 2008 there will be a new feature to do this for you in
> Enterprise Edition, according to:
>
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/21/elaborations-on-my-> sql-server-2008-slides.aspx
>
http://blog.benhall.me.uk/2007/06/sql-server-2008-change-data-capture-cdc.html>
>
> RLF
>
> "Noah" <noah@carpathiahost.com> wrote in message
> news:%23Y2r7NlEIHA.6120@TK2MSFTNGP05.phx.gbl...
>> I would like to be able to find out what user account made changes to a few
>> tables on my DB. I am not exactly a SQL DBA but i am sure there are a few
>> places that i can look. I did not see anything in the SQL Database
>> logfiles. Anything that i can check.
>
>
